| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> 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
 |
 |