Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-8768

implement support for interleaving btree and non btree cursors in query optimizer cursor selection code

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Geo, Querying
    • Labels:

      The query optimizer implementation for speculatively evaluating cursors produced by multiple query plans currently only supports btree and unindexed cursors. Certain geo cursors are not supported, and as a result all non btree cursors are excluded from speculative evaluation. This means that non btree cursors are only used to resolve an unhinted query when no btree cursors are helpful candidates for the query, as described in SERVER-4531. A hint can still be used to force usage of a non btree index in such cases.

      Instead it may be desirable for the query optimizer to support speculative evaluation of btree and non btree cursors simultaneously.

            hari.khalsa@10gen.com hari.khalsa@10gen.com
            aaron Aaron Staple
            1 Vote for this issue
            3 Start watching this issue