-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Component/s: query
-
Labels:
Currently for queries involving unique index like
SELECT * FROM [nt:base] WHERE [jcr:uuid] = $id
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