Computer scienceFundamentalsSQL and DatabasesDBMSMongoDBOptimization

Explain

Optimization for explain stages

Report a typo

For each query stage of explain operator tick the appropriate possible optimizing actions.

Choose one option for each row

	Create an index to speed up the query	Reduce the amount of data being queried	Optimize the query to reduce the number of documents being fetched	Add an index that includes the sort order	Add the desired fields to the index to avoid the FETCH stage
COLLSCAN
IXSCAN
FETCH
SORT
SHARD_MERGE

___

Create a free account to access the full topic