Oracle does I/O by blocks. Therefore, the optimizer's decision to use full table scans is influenced by the percentage of blocks accessed, not rows. This is called the index clustering factor. If blocks contain single rows, then rows accessed and blocks accessed are the same.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9524377/viewspace-673736/
,如需转载,请注明出处,否则将追究法律责任。