Re: Function based nvl index
- From: Mohamed Houri <mohamed.houri@xxxxxxxxx>
- To: raju raju <rajugaru.vij@xxxxxxxxx>
- Date: Tue, 23 Apr 2013 14:20:15 +0200
What is your cursor_sharing value?
SQL> sho parameter %cursor%
NAME TYPE VALUE
------------------------------------ ----------- ------------
cursor_sharing string EXACT
cursor_space_for_time boolean FALSE
open_cursors integer 500
session_cached_cursors integer 20
and could you post the execution plan with the predicate part?
Best Regards
Mohamed Houri
www.hourim.wordpress.com
2013/4/23 <rajugaru.vij@xxxxxxxxx>
> 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
>
>
>
--
Bien Respectueusement
Mohamed Houri
--
//www.freelists.org/webpage/oracle-l
Other related posts:
