Re: SQL Tuning on a date

descentr wrote:

> 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

Which optimizer?

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