The clustering_factor,1444800 seems to be high.
If this is equivalent to table's blocks, then it may not be a good index.
select table_name, blcoks
from dba_tables
where table_name ='XXXXX';
Run this query and let me know the value.
Tamil
|
Results 1 to 10 of 23
Thread: Query PerfomanceThreaded View
|
Click Here to Expand Forum to Full Width |