Re: Date Fields

From: TurkBear <johng_at_mm.com>
Date: Mon, 11 Oct 1999 17:31:04 GMT
Message-ID: <38031ea9.8990998@super.news-ituk.to>

Check the show plan output from this, but I believe that any function used in a where clause forces a full table scan...

amerar_at_ci.chi.il.us wrote:

>
>
>Hello,
>
>I have a question about date fields. We have a report that uses the
>date fields in the where clause. So, we created an index on this field
>to speed up the query. This works fine if we use a TO_DATE parameter.
>But if we use the TRUNC verb, then it seems like the index is not used
>because it takes forever......
>
>Why is this?
>
>Thanks,
>
>Arthur
>amerar_at_ci.chi.il.us
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Oct 11 1999 - 12:31:04 CDT