2. Using Ingres Commands : optimizedb Command—Generate Statistics for the Query Optimizer : optimizedb Example: Generate Full Statistics for a Database
 
Share this page                  
optimizedb Example: Generate Full Statistics for a Database
This command generates full statistics for all columns in all tables owned by you in the empdata database:
optimizedb empdata