Re: DBMS_STATS Syntax

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 10 Apr 2003 01:52:50 GMT
Message-ID: <S74la.291$OW4.136@news01.roc.ny.frontiernet.net>

A look at the manual (and I don't know why the OP did not look in it?)

it should probably be:
FOR ALL INDEXED COLUMNS SIZE 30 FOR ALL TABLES .. FOR ALL INDEXES don't make much sense. Since we are gathering schema stats .. so probably do mean "all tables" and cascade => true would mean "all indexes".

method_opt is for gathering histograms...

Anurag

"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message news:1c211608057beaf85db85ce2944efbb5_at_news.teranews.com...
> > Shouldn't that be
> > FOR INDEXES
> > not
> > FOR ALL INDEXES
> >
>
>
Received on Wed Apr 09 2003 - 20:52:50 CDT