Compiling:
- pre-evaluating db:open("CDI")
- rewriting ($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal >= "-5.8447265625")
- rewriting ($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "20.5224609375")
- rewriting ($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal >= "33.02708758002874")
- rewriting ($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "46.46813299215554")
- rewriting (string($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) >= "2012-03-17")
- rewriting (string($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) <= "2015-06-22")
- rewriting ("-5.8447265625" <= $x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal and $x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "20.5224609375" and "33.02708758002874" <= $x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal and $x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "46.46813299215554" and "2012-03-17" <= string($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) and string($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) <= "2015-06-22" and ($x_1/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:resourceConstraints/gmd:MD_LegalConstraints/gmd:otherConstraints/gmx:Anchor/text() = "unrestricted"))
- inlining $db_0
- applying text index for "unrestricted"
- rewriting where clause(s)
Query:
xquery version "3.0"; declare namespace queryName ='GetIDS'; declare namespace gco = "http://www.isotc211.org/2005/gco"; declare namespace gmd = "http://www.isotc211.org/2005/gmd"; declare namespace gml = "http://www.opengis.net/gml"; declare namespace gmx="http://www.isotc211.org/2005/gmx"; declare namespace sdn = "http://www.seadatanet.org"; declare namespace fn = "http://www.w3.org/2005/xpath-functions"; declare namespace xs = "http://www.w3.org/2001/XMLSchema"; declare namespace output = "http://www.w3.org/2010/xslt-xquery-serialization"; declare option output:method 'xml';declare option output:item-separator ","; let $db := db:open("CDI") for $x in $db where $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal>="-5.8447265625" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal<="20.5224609375" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal>="33.02708758002874" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal<="46.46813299215554" and string($x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition)>="2012-03-17" and string($x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition)<="2015-06-22" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:resourceConstraints/gmd:MD_LegalConstraints/gmd:otherConstraints/gmx:Anchor/text() = ("unrestricted") return db:node-pre($x)
Optimized Query:
for $x_1 in db:text("CDI", "unrestricted")/parent::gmx:Anchor/parent::gmd:otherConstraints/parent::gmd:MD_LegalConstraints/parent::gmd:resourceConstraints/parent::sdn:SDN_DataIdentification/parent::gmd:identificationInfo/parent::gmd:MD_Metadata/..[self::document-node()]["-5.8447265625" <= gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal][gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "20.5224609375"]["33.02708758002874" <= gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal][gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "46.46813299215554"]["2012-03-17" <= string(gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) <= "2015-06-22"] return db:node-pre($x_1)
Result:
- Hit(s): 15 Items
- Updated: 0 Items
- Printed: 144 Bytes
- Read Locking: local [CDI]
- Write Locking: none
Timing:
- Parsing: 12.17 ms
- Compiling: 22.36 ms
- Evaluating: 29755.1 ms
- Printing: 1.44 ms
- Total Time: 29791.07 ms
Query plan:
<QueryPlan compiled="true">
  <GFLWOR>
    <For>
      <Var name="$x" id="1"/>
      <CachedPath>
        <ValueAccess data="CDI" type="TEXT">
          <Str value="unrestricted" type="xs:string"/>
        </ValueAccess>
        <IterStep axis="parent" test="gmx:Anchor"/>
        <IterStep axis="parent" test="gmd:otherConstraints"/>
        <IterStep axis="parent" test="gmd:MD_LegalConstraints"/>
        <IterStep axis="parent" test="gmd:resourceConstraints"/>
        <IterStep axis="parent" test="sdn:SDN_DataIdentification"/>
        <IterStep axis="parent" test="gmd:identificationInfo"/>
        <IterStep axis="parent" test="gmd:MD_Metadata"/>
        <CachedStep axis="parent" test="node()">
          <CachedPath>
            <IterStep axis="self" test="document-node()"/>
          </CachedPath>
          <CmpSR min="-5.8447265625" max="">
            <CachedPath>
              <IterStep axis="child" test="gmd:MD_Metadata"/>
              <IterStep axis="child" test="gmd:identificationInfo"/>
              <IterStep axis="child" test="sdn:SDN_DataIdentification"/>
              <IterStep axis="child" test="gmd:extent"/>
              <IterStep axis="child" test="gmd:EX_Extent"/>
              <IterStep axis="child" test="gmd:geographicElement"/>
              <IterStep axis="child" test="gmd:EX_GeographicBoundingBox"/>
              <IterStep axis="child" test="gmd:westBoundLongitude"/>
              <IterStep axis="child" test="gco:Decimal"/>
            </CachedPath>
          </CmpSR>
          <CmpSR min="" max="20.5224609375">
            <CachedPath>
              <IterStep axis="child" test="gmd:MD_Metadata"/>
              <IterStep axis="child" test="gmd:identificationInfo"/>
              <IterStep axis="child" test="sdn:SDN_DataIdentification"/>
              <IterStep axis="child" test="gmd:extent"/>
              <IterStep axis="child" test="gmd:EX_Extent"/>
              <IterStep axis="child" test="gmd:geographicElement"/>
              <IterStep axis="child" test="gmd:EX_GeographicBoundingBox"/>
              <IterStep axis="child" test="gmd:eastBoundLongitude"/>
              <IterStep axis="child" test="gco:Decimal"/>
            </CachedPath>
          </CmpSR>
          <CmpSR min="33.02708758002874" max="">
            <CachedPath>
              <IterStep axis="child" test="gmd:MD_Metadata"/>
              <IterStep axis="child" test="gmd:identificationInfo"/>
              <IterStep axis="child" test="sdn:SDN_DataIdentification"/>
              <IterStep axis="child" test="gmd:extent"/>
              <IterStep axis="child" test="gmd:EX_Extent"/>
              <IterStep axis="child" test="gmd:geographicElement"/>
              <IterStep axis="child" test="gmd:EX_GeographicBoundingBox"/>
              <IterStep axis="child" test="gmd:southBoundLatitude"/>
              <IterStep axis="child" test="gco:Decimal"/>
            </CachedPath>
          </CmpSR>
          <CmpSR min="" max="46.46813299215554">
            <CachedPath>
              <IterStep axis="child" test="gmd:MD_Metadata"/>
              <IterStep axis="child" test="gmd:identificationInfo"/>
              <IterStep axis="child" test="sdn:SDN_DataIdentification"/>
              <IterStep axis="child" test="gmd:extent"/>
              <IterStep axis="child" test="gmd:EX_Extent"/>
              <IterStep axis="child" test="gmd:geographicElement"/>
              <IterStep axis="child" test="gmd:EX_GeographicBoundingBox"/>
              <IterStep axis="child" test="gmd:northBoundLatitude"/>
              <IterStep axis="child" test="gco:Decimal"/>
            </CachedPath>
          </CmpSR>
          <CmpSR min="2012-03-17" max="2015-06-22">
            <FnString name="string([item])">
              <CachedPath>
                <IterStep axis="child" test="gmd:MD_Metadata"/>
                <IterStep axis="child" test="gmd:identificationInfo"/>
                <IterStep axis="child" test="sdn:SDN_DataIdentification"/>
                <IterStep axis="child" test="gmd:extent"/>
                <IterStep axis="child" test="gmd:EX_Extent"/>
                <IterStep axis="child" test="gmd:temporalElement"/>
                <IterStep axis="child" test="gmd:EX_TemporalExtent"/>
                <IterStep axis="child" test="gmd:extent"/>
                <IterStep axis="child" test="gml:TimePeriod"/>
                <IterStep axis="child" test="gml:beginPosition"/>
              </CachedPath>
            </FnString>
          </CmpSR>
        </CachedStep>
      </CachedPath>
    </For>
    <DbNodePre name="node-pre(nodes)">
      <VarRef>
        <Var name="$x" id="1"/>
      </VarRef>
    </DbNodePre>
  </GFLWOR>
</QueryPlan>