Rafu on db: Usefull indexes

2010-09-24

Usefull indexes

Do we actually need such indexes?


select owner,table_name,index_name 
  from all_indexes 
 where distinct_keys < 2
   and num_rows > 100;

1 comment:

PdVOctober 4, 2010 at 7:37 PM
It all depends.

for ex:
Select whatever, to, do
from workingtable
where Status = 'WIP'

Status columns may have only 1 value when stats_gather runs, but may have a few, and mostly skewed values during actual operations.

dont rule out funny situations.
ReplyDelete
Replies

Subscribe to: Post Comments (Atom)