Re: Is ANALYZE INDEX necessary after REBUILD?

From: <markp7832_at_my-deja.com>
Date: Tue, 16 Nov 1999 20:56:44 GMT
Message-ID: <80sgea$j1j$1@nnrp1.deja.com>

In article <383165ae.17466004_at_zv>,
reinhard_wahl_at_gmx.de (Reinhard) wrote:
> Hi there,
>
> is it necessary to do an ANALYZE INDEX after a REBUILD?
>
> We have performance problems and i want to know if this could be a
> reason!
>
> We are running ORACLE V7.3.4.3.1 on HP-UX 10.20
>
> Thanks in advance!
> Reinhard
> --------------------------------------------------
> Replace the '_' with '.' in e-mail adress to reply
> ---------------------------------------------------------------------
As a general rule it is wise to re-analyze an object after doing maintenance on it. You could just do the index or you could re-analyze the table.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 14:56:44 CST