Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cost of index range scan
and the data_type of acct_date would be?
In my experience the selectivity of an index on a date column
(especially if the time is included) will be calculated as 1/NDV
ignoring any histogram, which will never be accurate enough.
I resolved this by a function based index.
Hth,
-- Sybrand Bakker Senior Oracle DBAReceived on Mon May 15 2006 - 09:29:44 CDT