Primary interfaces in Query Planner SQL Server

Asked By dawn fraserr 0 points N/A Posted on - 02/04/2013

Dear Experts,
What are primary interfaces in Query Planner SQL Server 2000? What commands are used to view textual view? What features are provided by SHOWPLAN ALL Command? Please write in detail

• Status: Open
• Question Views: 582
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Jemison Stacy 0 points N/A #165539

Primary interfaces in Query Planner SQL Server

Hi Dawn,

In SQL Server 2000 the primary interface is the graphical interface of the Query Analyzer, where it is very useful to hover over the object to determine the statistics. There are three different options in SQL Server 2000 to access the query plan. The First one is SHOWPLAN_TEXT command which offers a textual view of the SQL Server optimizer's query plan. The next command is the SHOWPLAN_ALL command which provides the estimated IO, CPU, row size, parallelism, etc. And the last one is the graphical query plan and it can be activated by Ctrl+K in query analyzer.

About Jemison Stacy

Questions
3

Answers
102

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 02/05/2013
• Question Category: MS SQL Server