Re: what's the SQL for dropping table statistics?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/02/29
Message-ID: <38BBA9DB.47C9@yahoo.com>#1/1

NetComrade wrote:
>
> I would like to analyze tables for chained rows and then drop
> collected statistics.
>
> Thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

analyze table XXX delete statistics;

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Tue Feb 29 2000 - 00:00:00 CST