The ASE connection-level options determine the default values for the launch configuration of newly created Adaptive Server Enterprise procedural objects and default values for SQL Editor, SQL File Editor, and SQL Scrapbook.
Property | Description | |
---|---|---|
Force Plan | Process a join in the same order as tables appear in the from clause of a select statement only. Default is off. | |
No Exec | Compile and return the query plan but not execute the query. Default is off. | |
Parse Only | Check the syntax of each Transact-SQL statement and return any error messages without compiling or executing the statement. Unlike No Exec, a Parse only statement without syntax errors can produce errors in compiling or execution time. Default is off. | |
Statistics IO | Display information on the amount of disk activity generated by Transact-SQL statements. Default is off. | |
Statistics Time | Display the number of milliseconds needed to parse, compile, and execute each statement. Default is off. | |
Statistics Subquery Cache | Display the number of cache hits, misses, and number of rows in the subquery cache for each subquery. Default is off. |
Property | Description | |
---|---|---|
Ignore Arithmetic Overflow | Ignore an arithmetic overflow or numeric truncation. Default is off. | |
Abort on Arithmetic Overflow | ASE aborts the current query or procedure when arithmetic overflow occurs. Default is on. | |
Abort on Arithmetic Truncation | ASE aborts the current query or procedure when arithmetic truncation occurs. Default is on. |
Property | Description | |
---|---|---|
Index Selection | Print index selection information in DBCC output. Default is off. | |
Join Selection | Print join selection information in DBCC output. Default is off. | |
Output to SQL Results View | Include DBCC information in the SQL Results view. Default is off. Available only when Index selection or Join selection is checked. | |
Output to Server Log | Include DBCC information in the server error log. Default is off. Available only when Index selection or Join selection is checked. |