The Database settings are Adaptive Server configuration parameter settings. These settings should correspond to how you have these parameters set in Adaptive Server.
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.
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.
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.
{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.
{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.
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.
Specify whether to include the DROP command before the CREATE object command.
Specify whether to place the database and user name in front of every object in the DDL.
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center