Knowledge Base

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

Article ID: 197581

Article Last Modified on 10/15/2002

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.

Additional query words: QA CRTL

Keywords: kbbug kbpending KB197581


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.