Re: Oracle 9.0.1.0.0 and the indexes ...

Jim Kennedy wrote:

> ANALYZE index yyy validate structure;
> does not analyze an index. Do as Brian suggests and use dbms_stats.
>

In the 9.2 Supplied PL/SQL packages manual, in the DBMS_STATS section, there is an explicit statement along the lines of "Oracle recommends using DBMS_STATS instead of Analyze."

I suspect they might soon be reserving ANALYZE for validation and deprecating ANALYZE for stats - but that's reading between the lines.

/Hans Received on Mon Jun 16 2003 - 23:01:49 CDT