Compiling:
- pre-evaluating collection("ALL-CDIS")
- pre-evaluating ("ALKY", "AYMD")
- rewriting ($x_0/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal >= "13.708333")
- rewriting ($x_0/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "15.708333")
- rewriting ($x_0/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal >= "45.6976667")
- rewriting ($x_0/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "55.6976667")
- rewriting (string($x_0/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) >= "2012-03-30T09:07:00")
- rewriting (string($x_0/gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) <= "2012-04-30T09:07:00")
- applying attribute index for "7827"
- 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")/gmd:MD_Metadata/gmd:identificationInfo/sdn:SDN_DataIdentification where $x/gmd:descriptiveKeywords/gmd:MD_Keywords/gmd:keyword/sdn:SDN_ParameterDiscoveryCode/@codeListValue = ("ALKY","AYMD") and $x/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal >= "13.708333" and $x/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "15.708333" and $x/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal >= "45.6976667" and $x/gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "55.6976667" and (string($x/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:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition)) <= ("2012-04-30T09:07:00") and $x/gmd:descriptiveKeywords/gmd:MD_Keywords/gmd:keyword/sdn:SDN_DeviceCategoryCode/@codeListValue = "130" and $x/gmd:descriptiveKeywords/gmd:MD_Keywords/gmd:keyword/sdn:SDN_EDMERPCode/@codeListValue = "7827" and $x/gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:organisationName/sdn:SDN_EDMOCode/@codeListValue = "120" and $x/gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:role/gmd:CI_RoleCode/@codeListValue="originator" and $x/gmd:resourceConstraints/gmd:MD_LegalConstraints/gmd:otherConstraints/gmx:Anchor/text() = "unrestricted" order by string($x/gmd:citation/gmd:CI_Citation/gmd:alternateTitle/gco:CharacterString) return string($x/gmd:citation/gmd:CI_Citation/gmd:alternateTitle/gco:CharacterString)
Optimized Query:
for $x_0 in db:attribute("ALL-CDIS", "7827")/self::codeListValue/parent::sdn:SDN_EDMERPCode/parent::gmd:keyword/parent::gmd:MD_Keywords/parent::gmd:descriptiveKeywords/parent::sdn:SDN_DataIdentification[parent::gmd:identificationInfo/parent::gmd:MD_Metadata/parent::document-node()][(gmd:descriptiveKeywords/gmd:MD_Keywords/gmd:keyword/sdn:SDN_ParameterDiscoveryCode/@codeListValue = ("ALKY", "AYMD"))]["13.708333" <= gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:westBoundLongitude/gco:Decimal][gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:eastBoundLongitude/gco:Decimal <= "15.708333"]["45.6976667" <= gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:southBoundLatitude/gco:Decimal][gmd:extent/gmd:EX_Extent/gmd:geographicElement/gmd:EX_GeographicBoundingBox/gmd:northBoundLatitude/gco:Decimal <= "55.6976667"]["2012-03-30T09:07:00" <= string(gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition)][string(gmd:extent/gmd:EX_Extent/gmd:temporalElement/gmd:EX_TemporalExtent/gmd:extent/gml:TimePeriod/gml:beginPosition) <= "2012-04-30T09:07:00"][(gmd:descriptiveKeywords/gmd:MD_Keywords/gmd:keyword/sdn:SDN_DeviceCategoryCode/@codeListValue = "130")][(gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:organisationName/sdn:SDN_EDMOCode/@codeListValue = "120")][(gmd:citation/gmd:CI_Citation/gmd:citedResponsibleParty/gmd:CI_ResponsibleParty/gmd:role/gmd:CI_RoleCode/@codeListValue = "originator")][(gmd:resourceConstraints/gmd:MD_LegalConstraints/gmd:otherConstraints/gmx:Anchor/text() = "unrestricted")] order by string($x_0/gmd:citation/gmd:CI_Citation/gmd:alternateTitle/gco:CharacterString) empty least return string($x_0/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: 16.1 ms
- Compiling: 146.47 ms
- Evaluating: 376.33 ms
- Printing: 0.07 ms
- Total Time: 538.99 ms
Query plan:
<QueryPlan compiled="true">
  <GFLWOR>
    <For>
      <Var name="$x" id="0"/>
      <CachedPath>
        <ValueAccess data="ALL-CDIS" type="ATTRIBUTE">
          <Str value="7827" type="xs:string"/>
        </ValueAccess>
        <IterStep axis="self" test="codeListValue"/>
        <IterStep axis="parent" test="sdn:SDN_EDMERPCode"/>
        <IterStep axis="parent" test="gmd:keyword"/>
        <IterStep axis="parent" test="gmd:MD_Keywords"/>
        <IterStep axis="parent" test="gmd:descriptiveKeywords"/>
        <IterStep axis="parent" test="sdn:SDN_DataIdentification">
          <CachedPath>
            <IterStep axis="parent" test="gmd:identificationInfo"/>
            <IterStep axis="parent" test="gmd:MD_Metadata"/>
            <IterStep axis="parent" test="document-node()"/>
          </CachedPath>
          <CmpG op="=">
            <CachedPath>
              <IterStep axis="child" test="gmd:descriptiveKeywords"/>
              <IterStep axis="child" test="gmd:MD_Keywords"/>
              <IterStep axis="child" test="gmd:keyword"/>
              <IterStep axis="child" test="sdn:SDN_ParameterDiscoveryCode"/>
              <IterStep axis="attribute" test="codeListValue"/>
            </CachedPath>
            <StrSeq size="2">
              <Str value="ALKY" type="xs:string"/>
              <Str value="AYMD" type="xs:string"/>
            </StrSeq>
          </CmpG>
          <CmpSR min="13.708333" max="">
            <CachedPath>
              <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="15.708333">
            <CachedPath>
              <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="45.6976667" max="">
            <CachedPath>
              <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="55.6976667">
            <CachedPath>
              <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-30T09:07:00" max="">
            <FnString name="string([item])">
              <CachedPath>
                <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>
          <CmpSR min="" max="2012-04-30T09:07:00">
            <FnString name="string([item])">
              <CachedPath>
                <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>
          <CmpG op="=">
            <CachedPath>
              <IterStep axis="child" test="gmd:descriptiveKeywords"/>
              <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"/>
            </CachedPath>
            <Str value="130" type="xs:string"/>
          </CmpG>
          <CmpG op="=">
            <CachedPath>
              <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"/>
            </CachedPath>
            <Str value="120" type="xs:string"/>
          </CmpG>
          <CmpG op="=">
            <CachedPath>
              <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"/>
            </CachedPath>
            <Str value="originator" type="xs:string"/>
          </CmpG>
          <CmpG op="=">
            <CachedPath>
              <IterStep axis="child" test="gmd:resourceConstraints"/>
              <IterStep axis="child" test="gmd:MD_LegalConstraints"/>
              <IterStep axis="child" test="gmd:otherConstraints"/>
              <IterStep axis="child" test="gmx:Anchor"/>
              <IterStep axis="child" test="text()"/>
            </CachedPath>
            <Str value="unrestricted" type="xs:string"/>
          </CmpG>
        </IterStep>
      </CachedPath>
    </For>
    <OrderBy>
      <Key dir="ascending" empty="least">
        <FnString name="string([item])">
          <IterPath>
            <VarRef>
              <Var name="$x" id="0"/>
            </VarRef>
            <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>
        </FnString>
      </Key>
    </OrderBy>
    <FnString name="string([item])">
      <IterPath>
        <VarRef>
          <Var name="$x" id="0"/>
        </VarRef>
        <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>
    </FnString>
  </GFLWOR>
</QueryPlan>