Re: SQL Tuning on a date

Mark C. Stock wrote:

> "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?

Would you really want to speed things up when out on a date? Sorry I asked. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)