Hi
all,
Can
anyone tell me which of the following performs better in collecting statistics
of a table:
Analyze
command or
Dbms_stats.gather_table_stats
I tried my queries with
both the options -- but always Analyze is out-performing the
dbms_stats.
But i read in a
document that Dbms_stats performs better !!
Besides I also read
that Analyze command will be deprecated from Oracle 9i.
So can anyone
tell me why dbms_stats is performing poor...
Are there any
paramters that need to be set to increase the performace of dbms_stats
?
Thanks in
advance.
Regards
Kesh
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful.
Visit us at http://www.cognizant.com