Error:
Interrupted.
Compiling:
- inlining Q{product_library}getCategory#1
- inlining $products_3
- simplifying flwor expression
- inlining $products_2
- simplifying flwor expression
Query:
import module 'product_library' at 'file:///C:/Users/ankumar/Desktop/product_library.xq'; declare namespace lib ="product_library"; declare namespace p="a:b:c"; let $products := /products/*[@catid] return count(lib:getCategory($products))
Optimized Query:
count(let $catRefs_4 := distinct-values(db:open-pre("large_products",0)/products/*[@catid]/@catid) return ((db:open-pre("large_products",2), ...))[(@id = $catRefs_4)])
Query plan:
<QueryPlan compiled="true">
  <FnCount name="count(items)">
    <GFLWOR>
      <Let>
        <Var name="$catRefs" id="4"/>
        <FnDistinctValues name="distinct-values(items[,collation])">
          <IterPath>
            <DBNode name="large_products" pre="0"/>
            <IterStep axis="child" test="products"/>
            <IterStep axis="child" test="*">
              <CachedPath>
                <IterStep axis="attribute" test="catid"/>
              </CachedPath>
            </IterStep>
            <IterStep axis="attribute" test="catid"/>
          </IterPath>
        </FnDistinctValues>
      </Let>
      <IterFilter>
        <ItemSeq size="300000">
          <DBNode name="large_products" pre="2"/>
          <DBNode name="large_products" pre="13"/>
          <DBNode name="large_products" pre="24"/>
          <DBNode name="large_products" pre="35"/>
          <DBNode name="large_products" pre="46"/>
        </ItemSeq>
        <CmpG op="=">
          <CachedPath>
            <IterStep axis="attribute" test="id"/>
          </CachedPath>
          <VarRef>
            <Var name="$catRefs" id="4"/>
          </VarRef>
        </CmpG>
      </IterFilter>
    </GFLWOR>
  </FnCount>
</QueryPlan>