Re: [basex-talk] path index does not seem to be used

Hi Fabrice,

this may be due to the existence of namespaces in your document. Various optimizations will only be triggered on documents with no namespaces, or a single default namespace.

Hope this helps, Christian ___________________________

On Tue, Feb 5, 2013 at 12:00 PM, Fabrice Etanchaud fetanchaud@questel.com wrote:

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>

---

BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk