[DOCS-14409] Make explanation of multikey index usage for sort more clear Created: 06/May/21  Updated: 30/Oct/23  Resolved: 04/Apr/22

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Task Priority: Major - P3
Reporter: Ian Boros Assignee: Ashley Brown
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 1 year, 44 weeks ago
Epic Link: DOCSP-11701
Story Points: 2

 Description   

Description

this page says:

As a result of changes to sorting behavior on array fields in MongoDB 3.6, when sorting on an array indexed with a multikey index the query plan includes a blocking SORT stage. The new sorting behavior may negatively impact performance.

Since SERVER-31898 has been fixed, the situation now (4.4 and later) is that we may, under certain circumstances, use the index (instead of a blocking sort) to answer these queries.

 

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Githook User [ 06/Apr/22 ]

Author:

{'name': 'Ashley Brown', 'email': '98361885+mdb-ashley@users.noreply.github.com', 'username': 'mdb-ashley'}

Message: DOCS-14409 Clarify multikey index usage (#773)

  • Updating multikey sort fact; added glossary entry for blocking sort
  • Bug fixes
  • Bug fixes
  • Bug fixes
  • Incorporating internal review comments
  • Removing example
  • tweaks
  • Resolving internal review comments
  • Incorporating review comments

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>
Branch: v6.0
https://github.com/10gen/docs-mongodb-internal/commit/1c86f648bf430c90811815b3446948cf770a3d3a

Comment by Githook User [ 05/Apr/22 ]

Author:

{'name': 'Ashley Brown', 'email': '98361885+mdb-ashley@users.noreply.github.com', 'username': 'mdb-ashley'}

Message: DOCS-14409 Clarify multikey index usage (#773) (#916)

  • Updating multikey sort fact; added glossary entry for blocking sort
  • Bug fixes
  • Bug fixes
  • Bug fixes
  • Incorporating internal review comments
  • Removing example
  • tweaks
  • Resolving internal review comments
  • Incorporating review comments

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>
Branch: v4.2
https://github.com/10gen/docs-mongodb-internal/commit/95092e95c0945f060bf983fd855fe88b80e581a5

Comment by Githook User [ 05/Apr/22 ]

Author:

{'name': 'Ashley Brown', 'email': '98361885+mdb-ashley@users.noreply.github.com', 'username': 'mdb-ashley'}

Message: DOCS-14409 Clarify multikey index usage (#773) (#915)

  • Updating multikey sort fact; added glossary entry for blocking sort
  • Bug fixes
  • Bug fixes
  • Bug fixes
  • Incorporating internal review comments
  • Removing example
  • tweaks
  • Resolving internal review comments
  • Incorporating review comments

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>
Branch: v4.4
https://github.com/10gen/docs-mongodb-internal/commit/2172ae9279ac2073b3381ad0ffabee5c2fa75fd9

Comment by Githook User [ 05/Apr/22 ]

Author:

{'name': 'Ashley Brown', 'email': '98361885+mdb-ashley@users.noreply.github.com', 'username': 'mdb-ashley'}

Message: DOCS-14409 Clarify multikey index usage (#773) (#914)

  • Updating multikey sort fact; added glossary entry for blocking sort
  • Bug fixes
  • Bug fixes
  • Bug fixes
  • Incorporating internal review comments
  • Removing example
  • tweaks
  • Resolving internal review comments
  • Incorporating review comments

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>
Branch: v5.0
https://github.com/10gen/docs-mongodb-internal/commit/6d137c64319937d6267682031d5ec94ba9b698ff

Comment by Githook User [ 05/Apr/22 ]

Author:

{'name': 'Ashley Brown', 'email': '98361885+mdb-ashley@users.noreply.github.com', 'username': 'mdb-ashley'}

Message: DOCS-14409 Clarify multikey index usage (#773) (#913)

  • Updating multikey sort fact; added glossary entry for blocking sort
  • Bug fixes
  • Bug fixes
  • Bug fixes
  • Incorporating internal review comments
  • Removing example
  • tweaks
  • Resolving internal review comments
  • Incorporating review comments

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>
Branch: v5.2
https://github.com/10gen/docs-mongodb-internal/commit/ba13931aac213a3465dec1ae3ca6698db6b70331

Comment by Githook User [ 04/Apr/22 ]

Author:

{'name': 'Ashley Brown', 'email': '98361885+mdb-ashley@users.noreply.github.com', 'username': 'mdb-ashley'}

Message: DOCS-14409 Clarify multikey index usage (#773)

  • Updating multikey sort fact; added glossary entry for blocking sort
  • Bug fixes
  • Bug fixes
  • Bug fixes
  • Incorporating internal review comments
  • Removing example
  • tweaks
  • Resolving internal review comments
  • Incorporating review comments

Co-authored-by: Ashley Brown <ashley.brown@m-hw46j45q6c.lan>
Branch: master
https://github.com/10gen/docs-mongodb-internal/commit/1c86f648bf430c90811815b3446948cf770a3d3a

Generated at Thu Feb 08 08:10:19 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.