You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Chetan Mehrotra (JIRA)" <ji...@apache.org> on 2016/10/07 09:49:21 UTC
[jira] [Created] (OAK-4904) For unique indexes avoid consulting
indexes other than property index
Chetan Mehrotra created OAK-4904:
------------------------------------
Summary: For unique indexes avoid consulting indexes other than property index
Key: OAK-4904
URL: https://issues.apache.org/jira/browse/OAK-4904
Project: Jackrabbit Oak
Issue Type: Improvement
Components: query
Reporter: Chetan Mehrotra
Assignee: Chetan Mehrotra
Fix For: 1.6
Currently for queries involving unique index like
{noformat}
SELECT * FROM [nt:base] WHERE [jcr:uuid] = $id
{noformat}
QueryEngine would start consulting all types of index in order of minimum cost. Where minimum cost are
* PropertyIndex - 2.0
* LucenePropertyIndex - 2.1
For such queries in case of match property index returns a cost of (base) 2 + (count) 1 = 3 due to which QE has to consult Lucene index also. Given such queries a very frequent it would be better to avoid consulting Lucene index as that adds unnecessary overhead
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)