Re: dates and indexes

In <4l93vf$pdr_at_dfw-ixnews3.ix.netcom.com>, yeazel_at_ix.netcom.com (Steve Yeazel) writes:
>
>If a date column has an index on it, does referencing that column with
>a to_char within the where clause cause the index not to be used?
>
>For instance,
>
>select * from tbl where to_char(datecol,'YYYY') = '1996';
>
>
>If datecol has an index on it, will it be used? I believe the answer
>is no, but want to confirm.
>
>Steve
>

Fears confirmed. A function on a date column kills the index.

D. Scott Moyer, Jr.                        dmoyer_at_gpu.com (work)
GPU Service Corporation                dsmoyer_at_enter.net (home)