Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: CBO choose full table scan, not index
...it also occurred to me that the cardinality calculated by the
optimizer is exactly the total number of rows /
(column_1_distinct_values * column2_distinct_values)
1071973 / ( 12 * 3) = 29777
It may not help, but it at least pushes you in a direction for the numbers the optimizer is using. Received on Tue Nov 27 2007 - 10:22:40 CST
![]() |
![]() |