It's reading between the lines, but not too much. Oracle has already
announced that they are not doing any further development on the ANALYZE
command (perataining to statistics), but are instead focusing on
DBMS_STATS.
Cheers,
Brian
Hans Forbrich wrote:
>
> 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
--
===================================================================
Brian Peasland
oracle_dba_at_remove_spam.peasland.com
Remove the "remove_spam." from the email address to email me.
"I can give it to you cheap, quick, and good. Now pick two out of
the three"
Received on Tue Jun 17 2003 - 09:33:36 CDT
