Re: Re-analyze Table After New Index ?

From: <fitzjarrell_at_cox.net>
Date: Wed, 29 Aug 2007 12:00:29 -0700
Message-ID: <1188414029.128577.66690@k79g2000hse.googlegroups.com>

On Aug 29, 1:14 pm, "userjohn" <userj..._at_mailinator.com> wrote:
> 10gR2
>
> If a couple of (non-unique) indexes are added to a table...
> is the table supposed to be re-analyzed (immediately) to be useful to the
> CBO ?
>
> thanks

Immediately, no, as the presence of the indexes may be enough for Oracle to know to use them. However the CBO might gain some added information with the updated statistics. I'll defer to Jonathan Lewis to give a definitive answer.

David Fitzjarrell Received on Wed Aug 29 2007 - 14:00:29 CDT