Ingres 12.0 | optimizedb Example: Generate Statistics for Certain Columns

Command Reference Guide > Command Reference Guide > Using Ingres Commands > optimizedb Command--Generate Statistics for the Query Optimizer > optimizedb Example: Generate Statistics for Certain Columns

Was this helpful?

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

Last modified date: 08/29/2024