The Forces page on the Optimization for Pre-ASE 15 tab of the Preferences window allows you to decide if you would like to have the Adaptive Server forces applied to alternative SQL statements. By adding an Adaptive Server force, you can force the Adaptive Server’s internal optimizer to choose a particular query plan.
Specify whether to enforce the tables to be joined in the order specified in the FROM clause.
{Adaptive Server 15 or later}
Specify whether to consider using merge joins. If selected, the parameter will toggle against the server sort_merge setting.
{Adaptive Server 15 or later}
Specify whether to use join transitive closure. If selected, the parameter will toggle against the server JTC setting.
{Adaptive Server 15 or later}
Specify the number of tables that the optimizer considers at one time while determining table join order.
PARALLEL
Specify whether to enforce the use of a particular parallelism degree to access the table if parallel query is enabled in the database server.
INDEX
Specify whether to enforce the use of a particular index to access the table.
Note: The forces that are marked with an asterisk are counted in the Number of forces selected on the Quota Preferences page.
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center
