Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sysdate query
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
![]() |
![]() |