Re: stats on indexes
Date: 17 Oct 2003 06:38:17 -0700
Message-ID: <2687bb95.0310170538.3742fb89_at_posting.google.com>
ndu35 <member29273_at_dbforums.com> wrote in message news:<3484958.1066236300_at_dbforums.com>...
> Yes, stats on indexes affects execution plans, but if you're using 9i
> oracle make a little sample on non-analyzed objects.
>
>
>
> Originally posted by Hrishy
>
> > Hi All
> >
> > I was just wundering what happens if we dont gather stats on indexes
> > will it effect the optimiser plans ?
> >
> > regards
>
> Hrishy
Depending on the option used to gather statistics Oracle often automatically generates index statistics when you generate statistics on the base table.
Example: analyze table bob.table_with_indexes compute statistiscs [OR sample] will generate statistics for the table and all its indexes.
HTH -- Mark D Powell -- Received on Fri Oct 17 2003 - 15:38:17 CEST