Re: Analyze

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 08 Oct 2002 15:17:08 GMT
Message-ID: <3DA2F6D4.13754AD7@exesolutions.com>

Stephan wrote:

> Oracle 7.3.4 and higher:
>
> - Is ANALYZING tables a MUST to achieve good performance?
> (imagine you NEVER analyze tables)
> - After an import (of a specific user/schema), do I have to analyze the
> tables?
> - Is there 1 command to analyze ALL tables at once?
>
> Thanks
> Stephan

Yes! Imagine that your performance is substantially less than it could be.
Yes! DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME=>schema_name, CASCADE=>TRUE);

Daniel Morgan Received on Tue Oct 08 2002 - 10:17:08 CDT