Oracle學習系列—資料庫優化—Statistics Summary

關於統計中表欄位索引所蒐集的相關資訊有那些....

Statistics generated include the following:

n Table statistics

– Number of rows

– Number of blocks

– Average row length

n Column statistics

– Number of distinct values (NDV) in column

– Number of nulls in column

– Data distribution (histogram)

n Index statistics

– Number of leaf blocks

– Levels

– Clustering factor

n System statistics

– I/O performance and utilization

– CPU performance and utilization

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/6517/viewspace-145525/，如需轉載，請註明出處，否則將追究法律責任。