Analyze oracle 9i

Hi everione, In my bd I have 3 partitioned tables, I try to analyze them and it takes a long time for each partition , more than 20 minutes.
Can anybody help me??
Thank you
Sonia.

use dbms_stats

go tahiti.oracle.com

Using this package I haven´t to delete last analyzed of partitions???

Se puede continuar en español?

dbms_stats lets you to analyze in parallel

Quote:

---

Originally posted by salvareztur
Se puede continuar en español?

---

of coz not

Este pl analiza tablas enteras no?? yo sólo quiero analizar algunas particiones de mis tablas, se le pasa el nombre de la partición como parámetro y ya o hay que pasarle otros parámetros??

sorry this is an English forum as you might have noticed from my previous reply

Sorry, I don´t understand you, sorry sorry.
Well I try to continue in English.
This PL analyze full tables or also can analyze partitions of one table.
I only want to analyze some partitions of my partitionated tables.

well if you looked my thread and go to tahiti.oracle.com you would see how this package works

thanks

what is the differentiate between use:
analyze table xxx subpartition yyy compute statistics
and
dbms_stats.gather_table_stats('zzz','table_name','partition_name')

Why the second option runs quickly and the first option runs very slowly.

That's why you need to see why dbms_stats is choosen against analyze table command.
The procedural nature, and the fact that dbms_stats directly collects stats on part. tables makes it work efficiently. analyze does the global stas which can also lead to inaccuracies.
So dump the analyze and keep using dbms_stats, in 9i there are more added advantages of dbms_stats, i suggest read some documentation to see the high difference these two tools may have.

but if I have analyzed partitionated tables using command analyze and now I use this plsql, I haven´t to delete previous statistics.
Is that Ok??