SQL Optimizer for SAP ASE 3.9 - Installation Guide

Database Setting

The Database settings are Adaptive Server configuration parameter settings. These settings should correspond to how you have these parameters set in Adaptive Server.

Set Ansinull (Default = Use database default)

Specify the option with regards to comparison of NULL values. Select Use database default to have the program check how the Set Ansinull parameter is set on Adaptive Server and set this parameter the same as it is set on the database.

Set Quoted_identifier (Default = Use database default)

Specify to allow the use of the delimited identifier (" ") for table names. This setting needs to be turned on if the space character is used in the name of tables or other database objects. Select Use database default to have the program check how the Set Quoted identifier parameter is set on Adaptive Server and set this parameter the same as it is set on the database.

Set Statistics Subquerycache On (Default = cleared)

Specify whether to display the number of cache hits, misses, and the number of rows in the subquery cache for each subquery in the All Records or First Record statistic information in the SQL Optimizer window.

Set Statistics Simulate On (Default = cleared)

{SAP Adaptive Server 15 or later}

Specify whether to load simulated statistics into the database. Simulated statistics can be generated using optdiag command and can be used to optimize SQL statements using the simulated statistics rather than the actual statistics.

Note: This can be used to simulate the production database statistics and optimize SQL statements in the development environment.

dbcc traceon (3604, 302, 310) (Default = cleared)

{sa_role privilege only}

Specify whether to display the trace on information in the SQL Optimizer and SQL Scanner windows. The trace on information displays the reasons why the Adaptive Server optimizer chooses to resolve the SQL statement in a particular way. This option is applicable only if you have sa_role privileges.