Re: analyze table question

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 22 Jan 2002 20:24:15 +0000
Message-ID: <3C4DCA6F.527D@yahoo.com>

a wrote:
>
> I am developping a script to analyze table. Should we also include tables
> belonging to SYS? Or it is not necessary? How about index rebuild? Should
> we also including all the index belonging to SYS as well?
>
> Thanks for your help.

see the other posts, and don't be tempted to use dbms_utility.analyze_Database (for the same reason)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Tue Jan 22 2002 - 14:24:15 CST