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)