Re: SQL Tuning on a date

From: Alan <alan_at_erols.com>
Date: Thu, 21 Oct 2004 14:47:56 -0400
Message-ID: <2tqej0F22tfmtU1@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. Received on Thu Oct 21 2004 - 13:47:56 CDT