Re: DBMS_STATS Syntax

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: Wed, 09 Apr 2003 19:56:18 GMT
Message-ID: <1c211608057beaf85db85ce2944efbb5@news.teranews.com>

> Shouldn't that be
> FOR INDEXES
> not
> FOR ALL INDEXES
>
> (I haven't checked the manual, though,
> so I may be wrong.)
>

Hello my British friend.

It looks strange, but doing it the old fashioned way, it seems like the right syntax.

SQL> CREATE TABLE TEMP_BT AS SELECT * FROM DUAL; Table created.

SQL> CREATE INDEX TEMP_BT_IDX ON TEMP_BT(DUMMY); Index created.

SQL> ANALYZE TABLE TEMP_BT COMPUTE STATISTICS FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS; Table analyzed.

SQL> ANALYZE TABLE TEMP_BT COMPUTE STATISTICS FOR TABLE FOR INDEXES FOR ALL INDEXED COLUMNS;
ANALYZE TABLE TEMP_BT COMPUTE STATISTICS FOR TABLE FOR INDEXES FOR ALL INDEXED COLUMNS

                                                       *

ERROR at line 1:
ORA-00905: missing keyword Received on Wed Apr 09 2003 - 14:56:18 CDT