RE: analyze vs dbms_stats

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Fri, 25 Jun 2004 12:13:50 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93B49@qtiexch2.qgraph.com>

AFAIK, the "FOR TABLE" is implied, and the "FOR ALL INDEXES" is = specified in the CASCADE clause, so you'd just need the "FOR ALL INDEXED = COLUMNS SIZE 254", methinks.

Give it a shot and lettuce snow what happens...

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----

Sent: Friday, June 25, 2004 12:07 PM
Subject: RE: analyze vs dbms_stats

In order to make the dbms generate the same sort of histograms would I replace the line to be as:
method_opt =3D3D> 'FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS = SIZE
254'

Is that the correct syntax?
Thanks
--

..
David

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Jun 25 2004 - 12:10:44 CDT