generate statistics

[cazpa]

Hi, I need generated all statistics for tables and index, because my database cost optimice_mode and i required my selects utility index.

thanks

[Axr2]

Use dbms_stats. RTM before implementing.

[cazpa]

I, used this command

analyze table xxx compute statistics
for table for all indexed columns for all indexes;

but not generate statistics

[cazpa]

where , i can find information about dbms_stat , because in metalink the informatio about this topic is very bad.

[Axr2]

Funny coz I found a 'few' hits on http://otn.oracle.com




Summary of Search Results: dbms_stats

Results for Oracle Database 10g Release 1 (10.1)
207 matches across 33 books. Search this documentation library.


--------------------------------------------------------------------------------

Results for Oracle9i Database (Release 2 (9.2))
74 matches across 17 books. Search this documentation library.

[pando]

Originally posted by cazpa
where , i can find information about dbms_stat , because in metalink the informatio about this topic is very bad.

strange, I didnt find the notes on Metalink that bad about this subject