Viewing the query plan of a SQL statement  Viewing a nested procedure

Chapter 11: Diagnosing System Problems

Viewing previous statements

To see the query plan for the previous statement in the same batch, issue sp_showplan with the same values as the original query, but subtract one from the statement number. Using this method, you can view all the statements in the statement batch back to query number one.





Copyright © 2005. Sybase Inc. All rights reserved. Viewing a nested procedure

View this book as PDF