Primary interfaces in Query Planner SQL Server

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #165539

Primary interfaces in Query Planner SQL Server

qa-featured

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.

Related Questions