<%@ page language="C#" masterpagefile="~/templates/Documentation.master" inherits="Page" pagetitle="Example of a Query Plan" keywords="Example of a Query Plan"%>
  • Chapter 1: Getting Started with Stylus Studio®
  • Chapter 2: Editing and Querying XML
  • Chapter 3: Converting Non-XML Files to XML
  • Chapter 4: Converting EDI to XML
  • Chapter 5: Working with XSLT
  • Chapter 6: Creating XSLT Using the XSLT Mapper
  • Chapter 7: Debugging Stylesheets
  • Chapter 8: Defining XML Schemas
  • Chapter 9: Defining Document Type Definitions
  • Chapter 10: Writing XPath Expressions
  • Chapter 11: Working with XQuery in Stylus Studio
  • Chapter 12: Composing Web Service Calls
  • Chapter 13: Working with WSDL Documents
  • Chapter 14: Building XML Pipelines
  • Chapter 15: Publishing XML Data
  • Chapter 16: Integrating with Third-Party File Systems
  • Chapter 17: Extending Stylus Studio
  • Chapter 18: The Stylus Studio Java API
  • Chapter 19: Stylus Studio GUI Reference

    • Home >Online Product Documentation >Table of Contents >Example of a Query Plan

    < Previous| Next >

    Example of a Query Plan

    The example query plan shown in Figure 363 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 363. Example of a Query Plan Displayed in the XQuery Editor

    < Previous| Next >