Similarity check

The value used is the system default setting that exists at execution.

SQL/MX recompiles the statement at run time, depending on the outcome of late name resolution, timestamp comparison, or table redefinition.

SQL/MX performs similarity checks at run time to determine whether the new table is similar to the previous table. If similar, SQL/MX uses the table without recompilation. Otherwise, the SQL statement is recompiled with the new table name. This setting is the default.