Re: oracle update query is taking lot of time..

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 3 Apr 2009 08:08:58 +0000 (UTC)
Message-ID: <gr4g6q$egr$1_at_solani.org>

Na Fri, 03 Apr 2009 00:39:50 -0700, Randolf Geist napisao:

>

>> You can create a functional index on NVL(mobilenumber,-1) and the same
>> for the rest of the columns, but unless you are on version 11g, you
>> cannot use statistics on that index. You can, however, use hints.

>
> Why can't you use statistics on that function-based index? What about
> e.g. "FOR ALL HIDDEN COLUMNS" as method_opt parameter in DBMS_STATS
> calls, and the virtual / hidden columns added behind the scenes are
> covered by "FOR ALL COLUMNS" (at least in 10.2) as well.
>
> Regards,
> Randolf
>

I am not at all certain that 10.2 will use histograms collected this way. I will try running that with the event 10053 and will post the results. The database is 10.2.0.4, so the results should be relevant.

-- 
http://mgogala.freehostia.com

Received on Fri Apr 03 2009 - 03:08:58 CDT