Re: Search between date ranges
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 30 Jul 2008 15:05:36 +0200
Message-ID: <4890671f$0$49882$e4fe514c@news.xs4all.nl>
Date: Wed, 30 Jul 2008 15:05:36 +0200
Message-ID: <4890671f$0$49882$e4fe514c@news.xs4all.nl>
"fitzjarrell_at_cox.net" <oratune_at_msn.com> schreef in bericht
news:6998cdca-ba5b-41a7-90ad-0907f7669703_at_f63g2000hsf.googlegroups.com...
>Comments embedded.
>(..............)
>Note both queries produce the same execution plan, with the same
>filter, as BETWEEN is silently rewritten to the form you've
>implemented.
>(..............)
>
>David Fitzjarrell
Yes but silently rewriting a query takes a lot of time... ;-)
Shakespeare Received on Wed Jul 30 2008 - 08:05:36 CDT