Database Options: Changed Defaults

If you are upgrading from an earlier release of SAP Sybase IQ, note that default values of some database options changed in release 16.0.

• JOIN_SIMPLIFICATION_THRESHOLD Option
  The default value for the JOIN_SIMPLIFICATION_THRESHOLD database option changed to12 in SAP Sybase IQ 16.0.
• MIN_PASSWORD_LENGTH Option
  The default value for the MIN_PASSWORD_LENGTH database option changed to 3 in SAP Sybase IQ 16.0.
• QUERY_PLAN Option
  The default value for the QUERY_PLAN database option changed to OFF in SAP Sybase IQ 16.0.
• QUERY_DETAIL Option
  The default value for the QUERY_DETAIL database option changed to ON in SAP Sybase IQ 16.0.
• QUERY_PLAN_AFTER_RUN Option
  The default value for the QUERY_PLAN_AFTER_RUN database option changed to ON in SAP Sybase IQ 16.0.
• QUERY_TIMING Option
  The default value for the QUERY_TIMING database option changed to ON in SAP Sybase IQ 16.0.