Ingres 11.0 | optimizedb Example: Allow Unique Values from Each Column in a Table

Command Reference Guide > Command Reference Guide > Using Ingres Commands > optimizedb Command--Generate Statistics for the Query Optimizer > optimizedb Example: Allow Unique Values from Each Column in a Table

Was this helpful?

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;

Last modified date: 01/30/2023