Online Documentation for SQL Manager for MySQL

Selecting fields for analyzing


This step of the wizard allows you to select fields of the table being edited for analyzing them.

 

Optimize field types wizard - Selecting fields

 

 

Max count of distinct values

Use this field to set the maximum number of distinct values per column that will be analyzed. This value is used to check whether the optimal data type should be of type ENUM; if there are more than defined value of distinct values, then ENUM is not a suggested type.

 

To select a field, you need to move it from the Available Fields list to the Included Fields list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the fields from one list to another.