Forces/Goal (ASE 15)
View Optimization for ASE 15 - Forces/Goals page
The Forces/Goal page on the Optimization for 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.
Set
Set Forceplan On
Specify whether to enforce the tables to be joined in the order specified in the FROM clause.
Parallel force
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 force
INDEX
Specify whether to enforce the use of a particular index to access the table.
Optimization Goal
allrows_mix
Specify to set the optimization goal for a database environment that is a mixture of online transactions and database warehouse transactions.
allrows_dss
Specify to set the optimization goal for a database environment that is purely for database warehouse transactions.
allrows_oltp
Specify to set the optimization goal for a database environment that is purely for oltp (online transaction processing) transactions.
fastfirstrow
Specify to set the optimization goal to retrieve the first row as fast as possible.
Note: The forces that are marked with an asterisk are counted in the Number of forces selected on the Quota Preferences page.