dynamobi/adminws — Issue #25: [DWS-7] Write server side EXPLAIN PLAN web services
Author: dynamobi-build
Created: 2011-12-30 01:07:10+00:00
State: open

[reporter="ngoodman", created="Thu, 4 Mar 2010 21:28:43 -0800", resolved="Tue, 8 Jun 2010 14:46:57 -0700"]

Write server side web services to return the "EXPLAIN PLAN" results SOAP/XML needed by FlexSQLAdmin. General format is:

StmtText,StmtId,NodeId,Parent,PhysicalOp,LogicalOp,Argument,DefinedValues,EstimateRows,EstimateIO,EstimateCPU,AvgRowSize,TotalSubtreeCost,OutputList,Warnings,Type,Parallel,EstimateExecutions,level

true
0
1

SELECT [fname], [lname], [coursename],
[semester] FROM [vwCompSci]

1
1
0
1
1

0.0563328229

SELECT
false
0

|--Sort(ORDER
BY:([tblCourses].[semester] ASC,
[tblCourses].[coursename] ASC,
[tblStudents].[lname] ASC,
[tblStudents].[fname] ASC))

1
2
1
Sort
Sort

ORDER BY:([tblCourses].[semester] ASC,
[tblCourses].[coursename] ASC,
[tblStudents].[lname] ASC,
[tblStudents].[fname] ASC)

1
0.0112612611
0.000100069
69

0.0563328229

[tblCourses].[coursename],
[tblCourses].[semester],
[tblStudents].[fname],
[tblStudents].[lname]

PLAN_ROW
false
1
1

|--Nested Loops(Inner Join, OUTER
REFERENCES:([tblEnrollment].[studentid]))

1
4
2
Nested Loops
Inner Join

OUTER
REFERENCES:([tblEnrollment].[studentid])

1
0
1.254E-05
290

0.0449713953

[tblCourses].[coursename],
[tblCourses].[semester],
[tblStudents].[fname],
[tblStudents].[lname]

PLAN_ROW
false
1
2

.....