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

From: Mladen Gogala <>
Date: Fri, 3 Apr 2009 08:08:58 +0000 (UTC)
Message-ID: <gr4g6q$egr$>

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, so the results should be relevant.

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

Original text of this message