Strange behaviour of function based index

Hello,

I encountered some strange behaviour of a function based index.

The Index: Create Index FooIndex on Footable(Trunc(aDate));

Executing the following query uses the index:

select Count(aDate) from Footable where Trunc(aDate) = Trunc(Sysdate);

But when I use the query without the 'Count', it uses a full table scan.

Can anyone explain this ??

Gerrit Received on Tue Apr 06 2004 - 05:48:30 CDT