Question

Point out the correct statement.

(a) Whether the use of a compound index or the use of an index intersection is more efficient depends on the particular query and the system

(b) Certain restrictions apply to indexes, such as the length of the index keys or the number of indexes per collection

(c) For queries that specify compound query conditions, if one index can fulfill a part of a query condition, and another index can fulfill another part of the query condition, then MongoDB can use the intersection of the two indexes to fulfill the query

(d) None of the mentioned

I had been asked this question in an international level competition.

The query is from Index Types topic in division Index/Indexing Concepts of MongoDB

Answer 1

The correct answer is (d) None of the mentioned

The best I can explain: In general, each index intersection involves two indexes; however, MongoDB can employ multiple/nested index intersections to resolve a query.