optimizedb Example: Generate Statistics for Certain Columns and Values, in Verbose Mode
The following command does the following (assuming you own the tables):
• Generates statistics for all key or indexed columns in employee, dept, and salhist.
• Processes the eno column in employee, whether or not eno is a key or indexed column.
• Generates statistics with only minimum and maximum values from the columns.
• Prints status information as each column is processed.
optimizedb
-zk
-zv
-zx
empdata
-remployee
-aeno
-rdept
-rsalhist;