Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cost of index range scan

Re: cost of index range scan

From: sybrandb <sybrandb_at_yahoo.com>
Date: 15 May 2006 07:29:44 -0700
Message-ID: <1147703384.535940.117160@v46g2000cwv.googlegroups.com>


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 DBA
Received on Mon May 15 2006 - 09:29:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US