Issue with mongoDB explain with collation in Mongo5

Rohith_Venkat_R · 2024-05-06T08:28:56.860Z

Hello,
When I am trying to do an explain on mongo5 when find and sort is on same attribute on which collation index is created. The same thing works seamless in mongo7. Do we have any work around for this in mongo5?

Pasted Graphic1330×572 40.4 KB

Pasted Graphic 11198×1866 243 KB

Topic	Replies	Views	Activity
Slow queries using wrong Index Working with Data queries	1	356	Jun 2024
Grouping results after $facet Working with Data aggregation	3	330	Jul 2024
Performance of query with many or conditions Working with Data	0	33	Oct 2024
IXSCAN with very large keysExamined value Working with Data aggregation	3	80	Dec 2024
Having different measurement fields in time-series collection documents Working with Data time-series	0	23	Dec 2024

Issue with mongoDB explain with collation in Mongo5

New & Unread Topics

Want to read more? Browse other topics in Working with Data or view latest topics.