![]() ![]() ![]() You know - if there was a "best way", it would be the only way.ģ) If you have my book - you know my opinion on this. ![]() ![]() dbms_utility has some very very primitive functions left in there for backwards compatibility only.Ģ) for that, please read the ADMIN guide, it covers the methods and when to use what. Most importantly, in the future, ANALYZE will not collect statistics needed byġ) dbms_stats is the one you should use. This can lead to inaccuracies for some statistics, such as the number of distinct values. For example, the table statistics gathered by DBMS_STATS include the number of rows, number of blocks currently containing data, and average row length but not the number of chained rows, average free space, or number of unused data blocks.ĭbms_stats (in 9i) can gather system stats (new)ĪNALYZE calculates global statistics for partitioned tables and indexes instead It is easier to automate with dbms_stats (it is procedural, analyze is just a command)ĭbms_stats is the stated, preferred method of collecting statisttics.ĭbms_stats can analyze external tables, analyze cannot.ĭBMS_STATS gathers statistics only for cost-based optimization it does not gather other statistics. You can import/export/set statistics directly with dbms_stats ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |