Function Based Index

Hi,
I have a function based index and a regular index on the same column of a table.

I have a table which has a column

date_of_story Date

I have created a function based index on it as

create index testme2 on news_story(trunc(date_of_story));

also i have create another regular non unique index on the same column .

what kind of effect will this have on performance.

Thanks
Ronnie

Still waiting

When a query carries a where clause that is not simillar in all respects literelly, then the index is not used.
Like , a table may have a normal index on column C1 and when used in querry C1='' then its fine, but
if you use C1=truncate(), then here the index is not used.
So, to over come that you would create the index based on your most application / query requirement.

Thanx
Sanjay