If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?

If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?
A . None of the above
B . The query used an index to fetch the results
C . The query returned 0 documents
D . The query returned 30000 documents after scanning the documents

View Answer

Answer: B