2. Using Ingres Commands : optimizedb Command—Generate Statistics for the Query Optimizer : optimizedb Example: Allow Unique Values from Each Column in a Table
 
Share this page                  
optimizedb Example: Allow Unique Values from Each Column in a Table
This command allows up to 100 unique values from each column in the employee table (owned by you) before merging adjacent values into the same histogram cell:
optimizedb
   -zu100
   empdata
   -remployee;