One of the collection has 2516269 document where one of the field is state with possible value of “OPEN” ,”EXCLUDED” . When I try to retrieve document with state:”OPEN” with match operator it is taking 3.3 sec … I am trying to reduce to 1 sec … can we do that …
Skip to main content
Yes by using a proper index.
New & Unread Topics
Topic | Replies | Views | Activity |
---|---|---|---|
Compound multikey index not used in sort and range query | 1 | 586 | Aug 2024 |
Installing kafka with k raft | 0 | 361 | Jun 2024 |
How to Populate data using Aggregate function | 1 | 407 | Jul 2024 |
Where clause not working in Atlas sql | 2 | 270 | Jul 2024 |
IXSCAN with very large keysExamined value | 3 | 80 | Dec 2024 |