Re: stats on indexes

From: ndu35 <member29273_at_dbforums.com>
Date: Wed, 15 Oct 2003 12:45:00 -0400
Message-ID: <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

>

> 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

Received on Wed Oct 15 2003 - 18:45:00 CEST

This message: [ Message body ]
Next message: LKBrwn_DBA: "Re: Problems with "IN""
Previous message: francis70: "How to read UNCOMMITED data in Oracle?"
Next in thread: Mark D Powell: "Re: stats on indexes"
Reply: Mark D Powell: "Re: stats on indexes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message