Re: to_date function

From: andrija <ar35644_at_fer.hr>
Date: Wed, 19 Dec 2001 12:45:40 +0100
Message-ID: <9vpulj$2jkf$1@as201.hinet.hr>

> > Yes, you can truncate the created_date, but that will force a full table
> > scan just to get the date component as of midnight.
>
> Is that true? I do not believe that. Where can I read about such.
>
> select * from tableA where trunc(created_date) = to_date('15/12/01',
> 'dd/mm/yy');

Yes it's true. How could Oracle use index on created_dt if your condition is trunc(created_date)?

Read something about function-based indexes. I think it's explained there. Received on Wed Dec 19 2001 - 05:45:40 CST