SORT with $limit larger than the cardinality should have the same cost as sort without a limit

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization
    • ALL
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None 

      Enterprise test> db.foo.find().sort({a:1}).hint({$natural: 1}).limit(10000000000).explain('executionStats').executionStats.executionStages.costEstimate;
17.516987879549447

Enterprise test> db.foo.find().sort({a:1}).hint({$natural: 1}).explain('executionStats').executionStats.executionStages.costEstimate;
32.13347149705384

            Assignee:
            Unassigned
            Reporter:
            Philip Stoev
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: