From Eigenpedia

For background, see FarragoExplainPlanExplained.

Example

0: jdbc:luciddb:> create schema x;
No rows affected (0.37 seconds)
0: jdbc:luciddb:> create table x.t1(i int);
No rows affected (1.126 seconds)
0: jdbc:luciddb:> create table x.t2(j int);
No rows affected (0.162 seconds)
0: jdbc:luciddb:> !set maxwidth 1000
0: jdbc:luciddb:> !set outputformat csv
0: jdbc:luciddb:> explain plan as xml for select * from x.t1,x.t2 where i=j;
'column0'
'<RelNode type="FennelToIteratorConverter">'
'       <Inputs>'
'               <RelNode type="LhxJoinRel">'
'                       <Property name="leftKeys">'
'                               [0]                     </Property>'
'                       <Property name="rightKeys">'
'                               [0]                     </Property>'
'                       <Property name="joinType">'
'                               INNER                   </Property>'
'                       <Inputs>'
'                               <RelNode type="LcsRowScanRel">'
'                                       <Property name="table">'
'                                               [LOCALDB, X, T1]                                 </Property>'
'                                       <Property name="projection">'
'                                               *                 </Property>'
'                                       <Property name="clustered indexes">'
' [SYS$CLUSTERED_INDEX$T1$I]                                      </Property>'
'                                       <Inputs/>'
'                               </RelNode>'
'                               <RelNode type="LcsRowScanRel">'
'                                       <Property name="table">'
'                                               [LOCALDB, X, T2]                                 </Property>'
'                                       <Property name="projection">'
'                                               *                 </Property>'
'                                       <Property name="clustered indexes">'
' [SYS$CLUSTERED_INDEX$T2$J]                                      </Property>'
'                                       <Inputs/>'
'                               </RelNode>'
'                       </Inputs>'
'               </RelNode>'
'       </Inputs>'
'</RelNode>'
32 rows selected (0.248 seconds)

Schema

XSD contributed by Doug Chesney:

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
elementFormDefault="qualified">
  <xs:element name="RelNode">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element ref="Inputs"/>
        <xs:element ref="Property"/>
      </xs:choice>
      <xs:attribute name="type" use="required" type="xs:NCName"/>
    </xs:complexType>
  </xs:element>
  <xs:element name="Inputs">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" maxOccurs="unbounded" ref="RelNode"/>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="Property">
    <xs:complexType mixed="true">
      <xs:attribute name="name" use="required"/>
    </xs:complexType>
  </xs:element>
</xs:schema>