2. Using Ingres Commands : optimizedb Command--Generate Statistics for the Query Optimizer : optimizedb Example: Generate Statistics for Certain Columns
 
Share this page                  
optimizedb Example: Generate Statistics for Certain Columns
This command generates statistics for key or indexed columns in the employee and dept tables and for the dno column in the dept table. The tables must be owned by you:
optimizedb -zk empdata -remployee -rdept -adno
This command performs the same operation as the previous example, but from a file:
optimizedb -zf flagfile
where flagfile contains:
-zk
empdata
-remployee
-rdept
-adno