Re: Function Based Index
From: Purav Chovatia <puravc_at_gmail.com>
Date: Thu, 20 Sep 2012 21:28:24 +0530
Message-ID: <CADrzpjGjmNMcDcMOfMw7LmZ9=yhkNhp76HOu=J08ix8OX325hg_at_mail.gmail.com>
Dumb of me to not know that "compute statistics" was redundant in 10g - Thanks Jonathan.
Since, in absence of statistics on the column, the optimizer (atleast in my case) chose the optimal plan. Hence, I think, not allowing Oracle to gather col stats for this table during the nightly window could be a second workaround (may be by locking the stats). The first workaround being an index hint.
Date: Thu, 20 Sep 2012 21:28:24 +0530
Message-ID: <CADrzpjGjmNMcDcMOfMw7LmZ9=yhkNhp76HOu=J08ix8OX325hg_at_mail.gmail.com>
Dumb of me to not know that "compute statistics" was redundant in 10g - Thanks Jonathan.
Since, in absence of statistics on the column, the optimizer (atleast in my case) chose the optimal plan. Hence, I think, not allowing Oracle to gather col stats for this table during the nightly window could be a second workaround (may be by locking the stats). The first workaround being an index hint.
On Tue, Sep 18, 2012 at 2:59 PM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk
> wrote:
>
> Purav,
>
> No - when you create the index (and "compute statistics" is redundant in
> 10g, by the way) Oracle doesn't collect stats on the table column.
>
>
> Regards
>
> Jonathan Lewis
> http://jonathanlewis.wordpress.com/all_postings
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 20 2012 - 10:58:24 CDT