View and Change Query Optimizer Plans

You can view the query optimizer plans, commands in the SQL command cache, or query plans for commands in the SQL command cache.

• Use the showplan Command

• View Commands and Explain Plans from the SQL Command Cache