Command Reference Guide > Command Reference Guide > Using Ingres Commands > optimizedb Command--Generate Statistics for the Query Optimizer > optimizedb Example: Generate Statistics for Certain Columns and Values, in Verbose Mode
Was this helpful?
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;
Last modified date: 08/29/2024