Re: Big tables and dates
Try a different date value that is closer to the smaller range of your data.
And, try changing the < to >.
If the value is close to the end of the available values, optimiser may decide that it is faster to read all rows sequentially than random read a fraction of the table rows.
Subject
Views
Written By
Posted
4370
November 20, 2007 06:04PM
Re: Big tables and dates
2479
November 21, 2007 02:02AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.