Covered query that spans across multiple indexes on same bucket

SQL++
, ,
1

We have 2 separate indexes on 2 different document types (“parent” doc and “child” doc) both exist on the same bucket. parent document has key(s) for the child document (there could be multiple child documents hence parent doc maintains an array of keys).

Is it possible to have a covered query that spans across both the indexes? (given that we are only selecting/querying on data residing on individual indexes)

2

If you doing JOIN or doing as subquery yes it can be covered.

i.e. each FROM clause source chooses different index it can be covered. single from Clause source chooses multiple indexes (Union Scan or IntersectScan) will not because each index maintained independent, asynchronously.