Compiling:
- pre-evaluating fn:collection("ALL-CDIS")
- pre-evaluating ("ALKY", "AYMD")
- rewriting ($x_0/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal >= "13.708333")
- rewriting ($x_0/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "15.708333")
- rewriting ($x_0/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal >= "45.6976667")
- rewriting ($x_0/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "55.6976667")
- rewriting (fn:string($x_0/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-30T09:07:00")
- rewriting (fn:string($x_0/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-04-30T09:07:00")
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- removing context expression (.)
- rewriting where clause(s)
Query:
xquery version "3.0"; 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"; for $x in collection("ALL-CDIS") where $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:descriptiveKeywords[*]/gmd:MD_Keywords/gmd:keyword[*]/sdn:SDN_ParameterDiscoveryCode/@codeListValue = ("ALKY","AYMD") and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal >= "13.708333" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "15.708333" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal >= "45.6976667" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "55.6976667" 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-30T09:07:00") 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-04-30T09:07:00") and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:descriptiveKeywords[*]/gmd:MD_Keywords/gmd:keyword/sdn:SDN_DeviceCategoryCode/@codeListValue = "130" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:descriptiveKeywords[*]/gmd:MD_Keywords/gmd:keyword/sdn:SDN_EDMERPCode/@codeListValue = "7827" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:organisationName/sdn:SDN_EDMOCode/@codeListValue = "120" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:role/gmd:CI_RoleCode/@codeListValue="originator" and $x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:resourceConstraints[*]/gmd:MD_LegalConstraints/gmd:otherConstraints/gmx:Anchor/text() = "unrestricted" order by string($x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:alternateTitle/gco:CharacterString) return string($x/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:alternateTitle/gco:CharacterString)
Optimized Query:
for $x_0 in (db:open-pre("ALL-CDIS",0), db:open-pre("ALL-CDIS",747), ...)[(gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:descriptiveKeywords[*]/gmd:MD_Keywords/gmd:keyword[*]/sdn:SDN_ParameterDiscoveryCode/@codeListValue = ("ALKY", "AYMD"))][gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "15.708333"]["45.6976667" <= 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 <= "55.6976667"]["2012-03-30T09:07:00" <= fn: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)][fn: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) <= "2012-04-30T09:07:00"][(gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:descriptiveKeywords[*]/gmd:MD_Keywords/gmd:keyword/sdn:SDN_DeviceCategoryCode/@codeListValue = "130")][(gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:descriptiveKeywords[*]/gmd:MD_Keywords/gmd:keyword/sdn:SDN_EDMERPCode/@codeListValue = "7827")][(gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:organisationName/sdn:SDN_EDMOCode/@codeListValue = "120")][(gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:role/gmd:CI_RoleCode/@codeListValue = "originator")][(gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:resourceConstraints[*]/gmd:MD_LegalConstraints/gmd:otherConstraints/gmx:Anchor/text() = "unrestricted")]["13.708333" <= gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal] order by fn:string($x_0/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:alternateTitle/gco:CharacterString) empty least return fn:string($x_0/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:alternateTitle/gco:CharacterString)
Result:
- Hit(s): 1 Item
- Updated: 0 Items
- Printed: 6 Bytes
- Read Locking: local [ALL-CDIS]
- Write Locking: none
Timing:
- Parsing: 0.82 ms
- Compiling: 73.88 ms
- Evaluating: 13846.56 ms
- Printing: 0.34 ms
- Total Time: 13921.59 ms
Query plan:
<QueryPlan>
  <GFLWOR>
    <For>
      <Var name="$x" id="0"/>
      <CachedFilter>
        <DBNodeSeq size="374739">
          <DBNode name="ALL-CDIS" pre="0"/>
          <DBNode name="ALL-CDIS" pre="747"/>
          <DBNode name="ALL-CDIS" pre="1494"/>
          <DBNode name="ALL-CDIS" pre="2197"/>
          <DBNode name="ALL-CDIS" pre="2900"/>
        </DBNodeSeq>
        <CmpG op="=">
          <IterPath>
            <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:descriptiveKeywords">
              <CachedPath>
                <IterStep axis="child" test="*"/>
              </CachedPath>
            </IterStep>
            <IterStep axis="child" test="gmd:MD_Keywords"/>
            <IterStep axis="child" test="gmd:keyword">
              <CachedPath>
                <IterStep axis="child" test="*"/>
              </CachedPath>
            </IterStep>
            <IterStep axis="child" test="sdn:SDN_ParameterDiscoveryCode"/>
            <IterStep axis="attribute" test="codeListValue"/>
          </IterPath>
          <StrSeq size="2">
            <Str value="ALKY" type="xs:string"/>
            <Str value="AYMD" type="xs:string"/>
          </StrSeq>
        </CmpG>
        <CmpSR min="" max="15.708333">
          <IterPath>
            <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"/>
          </IterPath>
        </CmpSR>
        <CmpSR min="45.6976667" max="">
          <IterPath>
            <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"/>
          </IterPath>
        </CmpSR>
        <CmpSR min="" max="55.6976667">
          <IterPath>
            <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"/>
          </IterPath>
        </CmpSR>
        <CmpSR min="2012-03-30T09:07:00" max="">
          <FNAcc name="string([item])">
            <IterPath>
              <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"/>
            </IterPath>
          </FNAcc>
        </CmpSR>
        <CmpSR min="" max="2012-04-30T09:07:00">
          <FNAcc name="string([item])">
            <IterPath>
              <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"/>
            </IterPath>
          </FNAcc>
        </CmpSR>
        <CmpG op="=">
          <IterPath>
            <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:descriptiveKeywords">
              <CachedPath>
                <IterStep axis="child" test="*"/>
              </CachedPath>
            </IterStep>
            <IterStep axis="child" test="gmd:MD_Keywords"/>
            <IterStep axis="child" test="gmd:keyword"/>
            <IterStep axis="child" test="sdn:SDN_DeviceCategoryCode"/>
            <IterStep axis="attribute" test="codeListValue"/>
          </IterPath>
          <Str value="130" type="xs:string"/>
        </CmpG>
        <CmpG op="=">
          <IterPath>
            <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:descriptiveKeywords">
              <CachedPath>
                <IterStep axis="child" test="*"/>
              </CachedPath>
            </IterStep>
            <IterStep axis="child" test="gmd:MD_Keywords"/>
            <IterStep axis="child" test="gmd:keyword"/>
            <IterStep axis="child" test="sdn:SDN_EDMERPCode"/>
            <IterStep axis="attribute" test="codeListValue"/>
          </IterPath>
          <Str value="7827" type="xs:string"/>
        </CmpG>
        <CmpG op="=">
          <IterPath>
            <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:citation"/>
            <IterStep axis="child" test="gmd:CI_Citation"/>
            <IterStep axis="child" test="gmd:citedResponsibleParty"/>
            <IterStep axis="child" test="gmd:CI_ResponsibleParty"/>
            <IterStep axis="child" test="gmd:organisationName"/>
            <IterStep axis="child" test="sdn:SDN_EDMOCode"/>
            <IterStep axis="attribute" test="codeListValue"/>
          </IterPath>
          <Str value="120" type="xs:string"/>
        </CmpG>
        <CmpG op="=">
          <IterPath>
            <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:citation"/>
            <IterStep axis="child" test="gmd:CI_Citation"/>
            <IterStep axis="child" test="gmd:citedResponsibleParty"/>
            <IterStep axis="child" test="gmd:CI_ResponsibleParty"/>
            <IterStep axis="child" test="gmd:role"/>
            <IterStep axis="child" test="gmd:CI_RoleCode"/>
            <IterStep axis="attribute" test="codeListValue"/>
          </IterPath>
          <Str value="originator" type="xs:string"/>
        </CmpG>
        <CmpG op="=">
          <IterPath>
            <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:resourceConstraints">
              <CachedPath>
                <IterStep axis="child" test="*"/>
              </CachedPath>
            </IterStep>
            <IterStep axis="child" test="gmd:MD_LegalConstraints"/>
            <IterStep axis="child" test="gmd:otherConstraints"/>
            <IterStep axis="child" test="gmx:Anchor"/>
            <IterStep axis="child" test="text()"/>
          </IterPath>
          <Str value="unrestricted" type="xs:string"/>
        </CmpG>
        <CmpSR min="13.708333" max="">
          <IterPath>
            <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"/>
          </IterPath>
        </CmpSR>
      </CachedFilter>
    </For>
    <OrderBy>
      <Key dir="ascending" empty="least">
        <FNAcc name="string([item])">
          <IterPath>
            <VarRef>
              <Var name="$x" id="0"/>
            </VarRef>
            <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:citation"/>
            <IterStep axis="child" test="gmd:CI_Citation"/>
            <IterStep axis="child" test="gmd:alternateTitle"/>
            <IterStep axis="child" test="gco:CharacterString"/>
          </IterPath>
        </FNAcc>
      </Key>
    </OrderBy>
    <FNAcc name="string([item])">
      <IterPath>
        <VarRef>
          <Var name="$x" id="0"/>
        </VarRef>
        <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:citation"/>
        <IterStep axis="child" test="gmd:CI_Citation"/>
        <IterStep axis="child" test="gmd:alternateTitle"/>
        <IterStep axis="child" test="gco:CharacterString"/>
      </IterPath>
    </FNAcc>
  </GFLWOR>
</QueryPlan>