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
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.
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.
Click Here to Expand Forum to Full Width