BUG: QA: No Execution Plan for DECLARE CURSOR & SELECT...FOR BROWSE (197581)
The information in this article applies to:
This article was previously published under Q197581
BUG #: 50958 (SQLBUG_70)
SYMPTOMS
In Query Analyzer, when you set the Execution Mode to show the execution
plan (either by clicking Show Execution Plan on the Query menu, or by using
the CTRL+K keystroke combination) on a DECLARE CURSOR statement, it does
not display a plan for cursor statements. If you click Display Estimated
Execution Plan on the Query menu (or use the CTRL+L keystroke combination),
you do see the execution plan for cursors.
CAUSE
When you set the Execution Mode to show the execution plan, the execution
plan contains IO statistics information. Because cursors do not support IO
statistics, an execution plan is not displayed. In Estimated Execution Plan
mode, IO statistics are not part of the execution plan.
WORKAROUND
To work around this problem, use the Estimated Execution Plan (CTRL+L).
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 7.0.
| Modification Type: | Major | Last Reviewed: | 10/15/2002 |
|---|
| Keywords: | kbBug KB197581 kbAudDeveloper |
|---|
|