Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » Interactive SQL Help » Introduction to Interactive SQL dialogs

Options dialog: Messages tab Next Page

Options dialog: Plan tab

The Plan tab of the Options dialog in Interactive SQL has the following components:

Plan    These options allow you to select the level of detail Interactive SQL provides about the way your query is optimized. Plan information appears on the Plan tab in the Results pane.

Assume read-only cursor    Select this option if you want the query optimizer to treat the query as if it had been executed for a read-only cursor. By default, this option is not selected, indicating that the optimizer should get the plan for a read-write cursor.

See PLAN function [Miscellaneous].

Assume cursor is    You can obtain a plan based on the type of cursor you specify. The query optimizer can assume the cursor is Asensitive, Insensitive, Sensitive, or Keyset-driven. The default is Asensitive.


See also