Search the manual and the web for PROCEDURE ANALYSE() and some examples
of how to use it. (It's not obvious how to get good results). I think
Ronald Bradford has a good blog post on it.

Benjamin Wiechman wrote:
> I recall there is a command that will display suggested optimal columns
> types for a given table based on the data stored in the table, but I haven't
> been able to figure out what it is.
>
>
>
> !
>
>
>
> Thanks.
>
>
>
> Ben Wiechman
>
> Wisper High Speed Internet
>
> ben@wisper-wireless.com
>
>
>
>