Re: Just as a learning exercise
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 4 May 2011 14:37:51 +0100
Message-ID: <BANLkTimeOSRatqWhuUhWyBET50Ci4CRz+Q_at_mail.gmail.com>
In the example given the logic is the same with and without the trunc the execution plan likely won't be if there is an idex on the column and the query is fairly selective (which I doubt) .
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
Date: Wed, 4 May 2011 14:37:51 +0100
Message-ID: <BANLkTimeOSRatqWhuUhWyBET50Ci4CRz+Q_at_mail.gmail.com>
In the example given the logic is the same with and without the trunc the execution plan likely won't be if there is an idex on the column and the query is fairly selective (which I doubt) .
On 4 May 2011 14:33, <TESTAJ3_at_nationwide.com> wrote:
to truncate the time component?
Joe
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
From:
Paul Drake <bdbafh_at_gmail.com>
To: tomdaytwo_at_gmail.com Cc: oracle-l <oracle-l_at_freelists.org> Date: 05/04/2011
09:23 AM Subject: Re: Just as a learning exercise Sent by:
oracle-l-bounce_at_freelists.org
Thomas,
Why would anyone ever apply a TRUNC ( ) function to a date column in a where
clause?
Is...
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 04 2011 - 08:37:51 CDT