stats on indexes

[hrishy]

Hi All

I was just wundering what happens if we dont gather stats on indexes
will it effect the optimiser plans ?

regards
Hrishy

[ndu35]

Re: stats on indexes


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


--
Posted via http://dbforums.com

[Mark D Powell]

Re: stats on indexes

ndu35 <member29273@db forums.comwrote in message news:<3484958.1 066236300@dbfor ums.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 --