Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

WHAT IS MEANT BY PLAN_ROW

Status
Not open for further replies.

2314

Programmer
Joined
May 19, 2001
Messages
69
Location
IN
WHAT IS MEANT BY PLAN_ROW
 
What context is PLAN_ROW being used in? It's not listed in the Books Online. Are you sure it's a Microsoft SQL Server command?

-SQLBill
 
plan_row is supposed to be a type of sql row but further than that i do not know
 
You are right, it is a MS SQL Server thing. I did a GOOGLE search using SQL and PLAN_ROW and it returned a Microsoft Library page on SET SHOWPLAN_ALL which mentioned 'PLAN_ROW type'. On that page there is a table which had the following description for Type:

Node type. For the parent node of each query, this is the Transact-SQL statement type (for example, SELECT, INSERT, EXECUTE, and so on). For subnodes representing execution plans, the type is PLAN_ROW.

That last line is the only description I could find for PLAN_ROW. Hope that helps.

-SQLBill
 
thanks for trying to help me
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top