Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

SETENV TPE_MM_COMPARE_OVHD

LEGACY Option

The type of query shown below was found to run slower than expected in certain situations:


SELECT (TOP k) * FROM tbl WHERE x BETWEEN a AND b ORDER BY y

The default cost estimates used in choosing an execution plan have been updated to improve general performance of this type of query. Additional options are also available to further adjust costing used in this optimization.

  • TPE_MM_COMPARE_OVHD (default value is 1)
  • TPE_MM_INSERT_OVHD (default value is 250)

Important: The MM subsystem was replaced with a new architecture beginning with V10.3. Only enable the legacy MM subsystem on the advice of FairCom's engineering team.

TOCIndex