Re: Just as a learning exercise
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: bdbafh@xxxxxxxxx
- Date: Wed, 4 May 2011 14:29:32 +0100
Based on the where 1=1 and lack if between I'd expect this to be machine
written
On 4 May 2011 14:23, "Paul Drake" <bdbafh@xxxxxxxxx> wrote:
Thomas,
Why would anyone ever apply a TRUNC ( ) function to a date column in a where
clause?
Is there no possibility that one might want to index that column at some
point?
Are you that fond of having to create function based indexes just because
devs can't write decent SQL statements?
Paul
On Wed, May 4, 2011 at 9:10 AM, Thomas Day <tomdaytwo@xxxxxxxxx> wrote:
>
> I've got a query in A...
Other related posts:
