Re: Date Fields

Hello,

An index will not be used if you perform any additional operation on the column, like TRUNC, in your case. The column is indexed as it is not as an output of certain operation.

Take care,
Ashok
--

On Mon, 11 Oct 1999 17:31:04 TurkBear wrote:
> Message from the Deja.com forum:
> comp.databases.oracle.server
> Your subscription is set to individual email delivery
>>
>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 ==-----
>
>
>
> _____________________________________________________________
> Deja.com: Before you buy.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.server
> * Read this thread at
> http://www.deja.com/thread/%3C38031ea9.8990998%40super.news-ituk.to%3E
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- Share what you know. Learn what you don't.

 Sent via Deja.com http://www.deja.com/  Before you buy. Received on Thu Oct 14 1999 - 10:39:06 CDT