Query is performing poorly even after using the index

Hi @vinodkumar_Mallikarj,

What @Prasad_Saya said is I believe the correct answer.

As an aside, if this is an actual query you use regularly, personally I would reevaluate the need to return 2886148 documents in a single query. It seems to be an excessive number, unless you’re doing a data export. A query returning an excessive amount of documents could interfere with your working set, leading to suboptimal performance in some cases.

Best regards,
Kevin

1 Like