adplus-dvertising
frame-decoration

Question

Point out the correct statement.

a.

If you only ever query on a single key in a given collection, then you need to create just multikey index for that collection

b.

If you sometimes query on only one key and at other times query on that key combined with a second key, then creating a compound index is more efficient than creating a single-key index

c.

The choice between creating compound indexes that support your queries or relying on index intersection is independent of specifics of your system

d.

None of the mentioned

Posted under MongoDB

Answer: (b).If you sometimes query on only one key and at other times query on that key combined with a second key, then creating a compound index is more efficient than creating a single-key index

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Point out the correct statement.