2.7.4.2 Auto Encoding Examples

• Running Auto Encoding to generate string column encoding recommendations for the tpch schema:

  mysql> CALL sys.heatwave_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('tpch'),
            'auto_enc',JSON_OBJECT('mode','recommend')));

• Running Auto Encoding with the fixed_enc option to force variable-length encoding for the tpch.CUSTOMER.C_ADDRESS column. Columns specified by the fixed_enc option are excluded from consideration by the Auto Encoding feature.

  mysql> CALL sys.heatwave_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('tpch'), 
            'auto_enc',JSON_OBJECT('mode','recommend','fixed_enc', 
             JSON_OBJECT('tpch.CUSTOMER.C_ADDRESS','varlen'))));