BUG: QA: No Execution Plan for DECLARE CURSOR & SELECT...FOR BROWSE

ID: Q197581

The information in this article applies to:

Microsoft SQL Server version 7.0

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.

Additional query words: QA CRTL

Keywords : kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug