Dear all at BaseX,

In a indexed database,

Query info shows that a request like Count(/a/b/c) does not use the statistics data available with index:facets().

Could you please tell me if this is really the case, and if there is a way to tell BaseX to use it ?

Best regards,

And thank you for your great XNDB !

Fabrice

Here is the query :

Query: declare namespace exch = 'http://www.epo.org/exchange';

count(/exch:exchange-documents/exch:exchange-document)

Query plan:

<QueryPlan>

  <FNAggr name="count(item)">

    <IterPath>

      <DBNodeSeq size="38">

        <DBNode name="DOCDB_RU" pre="0"/>

        <DBNode name="DOCDB_RU" pre="4198620"/>

        <DBNode name="DOCDB_RU" pre="7369614"/>

        <DBNode name="DOCDB_RU" pre="11083006"/>

        <DBNode name="DOCDB_RU" pre="15423603"/>

      </DBNodeSeq>

     <IterStep axis="child" test="exch:exchange-documents"/>

      <IterStep axis="child" test="exch:exchange-document"/>

    </IterPath>

  </FNAggr>

</QueryPlan>

Here is the db:info() :

<database>

  <databaseproperties>

    <name>DOCDB_RU</name>

    <size>3391 MB</size>

    <nodes>135589551</nodes>

    <documents>38</documents>

    <binaries>0</binaries>

    <timestamp>2013-01-29-23-16-31</timestamp>

  </databaseproperties>

  <resourceproperties>

    <inputpath>C:/data/work/docdb/RU</inputpath>

    <timestamp>2012-12-28-06-53-45</timestamp>

    <encoding>UTF-8</encoding>

    <whitespacechopping>ON</whitespacechopping>

  </resourceproperties>

  <indexes>

    <uptodate>true</uptodate>

    <textindex>ON</textindex>

    <attributeindex>ON</attributeindex>

    <fulltextindex>OFF</fulltextindex>

    <updindex>ON</updindex>

    <maxcats>10000</maxcats>

    <maxlen>96</maxlen>

  </indexes>

</database>