April 10, 2003 at 10:25 am
I can't get a graphical execution plan from Query Analyzer when I have temporary tables. Does anybody know what do do about that?
April 10, 2003 at 10:41 am
I look at execution plans with temp tables in them all the time. I do not know of any reason you should not be able to do the same. Or are you doing an estimated execution plan? If so, don't use the estimation, but actually run your query and display the actual plan......
April 10, 2003 at 11:24 am
I'm trying to look at the plan for a stored procedure that uses a temporary table. I'm doing this by entering the command "EXEC SP_NAME" and then pressing the "Display Estimated Execution Plan" button on the toolbar. Are you talking about using "SET STATISTICS PROFILE ON" and then running the query?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply