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.
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.