12. Using the Query Optimizer : Specialized Statistics Processing : Display Optimizer Statistics : Display Optimizer Statistics for Individual Tables and Columns
 
Share this page                  
Display Optimizer Statistics for Individual Tables and Columns
By default, optimizer statistics are shown for all tables and columns in the current database, but you can view statistics for specific table columns.
The following command lists statistics for the empno column of the emp table:
statdump demodb -remp -aempno
In Director or VDBA, use the Specify Tables and Specify Columns check boxes in the Display Statistics dialog.