Viewing short and long text plans

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

  2. Execute the EXPLANATION function.

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

  2. Execute the PLAN function.

 See also