Function based nvl index
- From: rajugaru.vij@xxxxxxxxx
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 23 Apr 2013 11:24:12 +0000
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
