Re: Function based nvl index
From: Mohamed Houri <mohamed.houri_at_gmail.com>
Date: Tue, 23 Apr 2013 14:20:15 +0200
Message-ID: <CAJu8R6izp3ip5YsWwrWcpRznLaJQMSeXG6dkbnSHBRhrY+2vfg_at_mail.gmail.com>
What is your cursor_sharing value?
SQL> sho parameter %cursor%
Date: Tue, 23 Apr 2013 14:20:15 +0200
Message-ID: <CAJu8R6izp3ip5YsWwrWcpRznLaJQMSeXG6dkbnSHBRhrY+2vfg_at_mail.gmail.com>
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_at_gmail.com>
> 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
>
>
>
-- Bien Respectueusement Mohamed Houri -- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 23 2013 - 14:20:15 CEST