Example of a Query Plan

The example query plan shown in Figure 331 provides information about how DataDirect XQuery translates the following query, which accesses one relational data source, into a SQL Select statement and how XML results are constructed.

declare option ddtek:plan-explain 'format=xhtml';
               
<myHoldings> {
               
for $holdings in collection("pubs.dbo.holdings")/holdings
               
where $holdings/userid = "Minollo"
               
return <holding
               
quantity="{$holdings/shares}">{$holdings/stockticker/text()}</holding>
               
}
               
</myHoldings>
               

            

In the following query plan, notice how the Relational Data Source node includes details about the SQL Select statement, as well as information about how the result ( $PT) is constructed.

Figure 331. Example of a Query Plan Displayed in the XQuery Editor

Key Benefits of DataDirect XML Converters

Learn how DataDirect XML Converters were created to maximize XML developer productivity, push innovation, and provide unquestioned value.

FLWOR - An Introduction to the XQuery FLWOR Expression

An XQuery FLWOR Tutorial, covering an introduction to the main constructs of the XQuery FLWOR expression, including: For, Let, Where, Order By, and Return. Written by the W3C's Dr. Michael Kay.

Energy Companies That Use Stylus Studio

Forget red bull! Many energy companies are using Stylus Studio 2006 for their quick pick me up during the work day. Come see which energy companies are getting the boost they need with Stylus Studio!

X12 Standards Available Across All Releases

The complete X12 Standards Grid, listing all X12 EDI releases across the top, and the corresponding transaction sets down the left side.

Stylus Most Wanted

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.