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 Forceplan On
Specify whether to enforce the tables to be joined in the order specified in the FROM clause.
Specify whether to enforce the use of a particular parallelism degree to access the table if parallel query is enabled in the database server.
Specify whether to enforce the use of a particular index to access the table.
Specify to set the optimization goal for a database environment that is a mixture of online transactions and database warehouse transactions.
Specify to set the optimization goal for a database environment that is purely for database warehouse transactions.
Specify to set the optimization goal for a database environment that is purely for oltp (online transaction processing) transactions.
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.