Function based nvl index

From: <rajugaru.vij_at_gmail.com>
Date: Tue, 23 Apr 2013 11:24:12 +0000
Message-ID: 1323408702-1366716251-cardhu_decombobulator_blackberry.rim.net-1330608508-_at_b28.c12.bise7.blackberry>

Hi,
I have a situation where my function based index is not getting used. Its an NVL based functional index

NVL(gender,0) =0

Is my where clause. And I have a index on NVL(gender,0)

It was getting used previously, but not now.

I use the some in update and select queries both the cases, index is not getting used.

Using 10g R2

Any thoughts?
Sent on my BlackBerry® from Vodafone--
http://www.freelists.org/webpage/oracle-l Received on Tue Apr 23 2013 - 13:24:12 CEST