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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Query Processing » Query optimization and execution » Reading execution plans » Reading text plans

 

Viewing short and long text plans

♦  To view a short text plan (SQL)
  1. Connect to a database as a user with DBA authority.

  2. Execute the EXPLANATION function. See EXPLANATION function [Miscellaneous].

♦  To view a long text plan (SQL)
  1. Connect to a database as a user with DBA authority.

  2. Execute the PLAN function. See PLAN function [Miscellaneous].