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].

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0