Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Database Setting

Preferences > Database Setting Tab > 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.

 

DDL Tab

DDL

Preferences > DDL Tab > DDL
ClosedView DDL page

The DDL tab of the Preferences window allows you define the way the DDL is extracted for the database objects in the Database Explorer and the Object Extractor.

Place a DROP command before the object (Default = checked)

Specify whether to include the DROP command before the CREATE object command.

Qualify object with database and user name (Default = cleared)

Specify whether to place the database and user name in front of every object in the DDL.

Include indexes for table (Default = checked)

Specify whether to include the CREATE INDEX command when the DDL for a table is extracted.

Note: The settings for this tab are also changed from the Extraction Criteria window that can be optionally displayed at the beginning of the extraction process in the Object Extractor.

 

Performance Monitor

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating