Chapter 16: Determining Sizes of Tables and Indexes
Disadvantages of optdiag
The disadvantages of optdiag are:
It produces a lot of output, so if you need only
a single piece of information, such as the number of pages in the
table, other methods are faster and have lower system overhead.