Re: Analyzing indexes

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 11 Mar 2003 19:45:21 +0100
Message-ID: <pkbs6vkmni8j42torqg98c1s6l96elh7lg@4ax.com>

On Tue, 11 Mar 2003 09:01:33 -0800, DA Morgan <damorgan_at_exesolutions.com> wrote:

>If I try to run an "analyze validate structure" to

>> gather the data I need to make that decision, it sets a lock on the
>> table for about an hour which I can't afford to do. T

Never seen analyze index validate structure taking an hour and evidently you need to analyze *ALL* of the index to get the correct statistical info.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 11 2003 - 12:45:21 CST