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: sysdate query

Re: sysdate query

From: <jernigam_at_kochind.com>
Date: 10 May 2006 14:41:33 -0700
Message-ID: <1147297293.443930.276390@i40g2000cwc.googlegroups.com>


I think I figured out why it was doing a full table scan when using

acctg_date > trunc(sysdate)
or useing
acctg_date > '01-May-2006'

After doing a 10053 trace, I found out that the filter factor it was using was 98%. It should really only be about 2%. That is probably due to the fact that there were some bad dates greater than '01-Jan-3000'.

When using "greater than" it calculates it based on the high and low values.
(hi-value)/(hi-low) Received on Wed May 10 2006 - 16:41:33 CDT

Original text of this message

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