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

exams C100DBA C100DBA exam 0 Comments

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

Answer: B