Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Forces/Goal (ASE 15)

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.

 

Related Topics

Related Documents