[DOCS-12845] Warn about old indexes for the "Array Sort Behavior" change in 3.6 compatibility notes Created: 01/Jul/19  Updated: 30/Oct/23  Resolved: 27/Oct/22

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

Type: Improvement Priority: Critical - P2
Reporter: Chris Harris Assignee: Unassigned
Resolution: Gone away Votes: 1
Labels: reopened
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 1 year, 14 weeks, 6 days ago
Epic Link: DOCSP-26173

 Description   

Description

The "Array Sort Behavior" section of the 3.6 compatibility notes discuss the change implemented via SERVER-19402.  There is a nice "IMPORTANT" note that mentions the potential performance degradation associated with this change when sorting on an array field.

It is also possible to encounter the degraded performance even if you are not sorting on the array field itself.  This occurs when the multikey index was built on version 3.2 or earlier and has not been rebuilt since upgrading to 3.4 which introduced multiKeyPaths metadata.  Without this metadata the optimizer only knows that some indexed field is an array, but not which one specifically.  As a result it must use the conservative behavior and generate a blocking sort to ensure correctness.  

Consider noting this caveat in the documentation as it is presently not clear what the problem is or what the fix is if a user were to encounter this situation.   

Scope of changes

Impact to Other Docs

MVP (Work and Date)

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



 Comments   
Comment by Emet Ozar [ 27/Oct/22 ]

Product version no longer supported

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