Viewing SQL Query Plans

You can view the query plan for a command in one of two ways: storing the latest query plan into the system PLAN table or viewing all cached commands and their query plans in the SQL command cache.

Both methods are described in the following sections:

• Viewing a Query Plan from the System PLAN Table

• Viewing Query Plans Associated with Commands Stored in the SQL Command Cache