Details
-
Improvement
-
Resolution: Unresolved
-
Minor
-
6.6.2, 6.5.2, Cheshire-Cat
-
None
-
1
Description
It would be useful to be able to create an index in such a way that it is not considered for use within queries unless the USE INDEX directive is specified. Consider creating an adaptive index which indexes the entirety of a document, in theory this index can be used for any query however it may not be the most performant to do so, but is performant for a small subset of queries. Rather than needing to specify USE INDEX on every query you do not want to use this new index for, it would instead be more beneficial to be able to tell the query to use that index, and the index only gets considered for those sorts of queries.
Have tagged this against both 2I and Query for the time being