Re: SQL Tuning on a date

"Alan" <alan_at_erols.com> wrote in message news:2tqej0F22tfmtU1_at_uni-berlin.de...
|
| "descentr" <descentr_at_hotmail.com> wrote in message
| news:Xns95897FD363672descentrhotmailcom_at_207.217.125.201...
| > I ran a query through an optimizer and one of the things it did (which
| > improved performance) was to add a "+ 0" to the two date fields in the
| > where clause.
| >
| > i.e. mytable.datefield + 0 > to_date('a date')
| >
| > What does this do?
| >
| > Mike
|
| At the risk of answering a homework question, it prevents the use of an
| index on that field under RBO.
|
|

and you did this when you were out on a date? Received on Thu Oct 21 2004 - 13:50:27 CDT