Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Tuning on a date
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 Received on Thu Oct 21 2004 - 12:34:32 CDT
![]() |
![]() |