Re: analyze table question

From: Stefan <sroesch3_at_attbi.com>
Date: Sat, 19 Jan 2002 05:35:46 GMT
Message-ID: <SA728.864$qn3.18906@rwcrnsc53>

Hi,

never ever analyze the sys schema or any objects that belong to it. The only object that can be analyzed is the sys.aud$ table. But this makes only sense if you are using auditing.

Regards
Stefan

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.
Received on Fri Jan 18 2002 - 23:35:46 CST