[
https://issues.apache.org/jira/browse/ASTERIXDB-2937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Glenn Justo Galvizo reassigned ASTERIXDB-2937:
----------------------------------------------
Assignee: Glenn Justo Galvizo
> Use atomic prefix from array indexes in queries w/o array element.
> ------------------------------------------------------------------
>
> Key: ASTERIXDB-2937
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2937
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: IDX - Indexes
> Reporter: Glenn Justo Galvizo
> Assignee: Glenn Justo Galvizo
> Priority: Major
>
> Given the multi-valued index:
>
> {code:java}
> CREATE INDEX someIdx ON SomeDataset (
> field1,
> field2,
> UNNEST arrayField
> SELECT field3, field4
> );{code}
> The following query could take advantage of the index above:
> {code:java}
> FROM SomeDataset D
> WHERE D.field1 = 1 AND D.field2 = 2
> SELECT *;{code}
> but is currently not. This is because we delay recognition of array index
> applicability until we see the array component of an array index. Work to
> realize this involves improving how we make the decision to use a prefix
> search for array indexes.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
