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

Support admin hints per query pattern

    XMLWordPrintable

    Details

    • Backwards Compatibility:
      Fully Compatible

      Description

      The query optimizer currently generates a query plan which is cached and re-used based on the normalized "shape" of the query predicate and sort criteria.

      1. Querying
        DBA's should be able to hint a query by plan id. This should be able to be set by a DBA on the server-side in addition to the current technique of putting the hint into the application itself.

        Attachments

          Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-12358 Add query plan history and logging

          • Major - P3 - Major loss of function.
          • Closed
          related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-9306 Ability to temporarily forbid query optimizer from using index ("invisible index")

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-5470 View memorized query optimized plans

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. DOCS-2595 add index filter commands

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-666 query optimizer introspection

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-8692 Add logging to indicate when cached query plan changes

          • Major - P3 - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              benety.goh Benety Goh
              Reporter:
              pasette Daniel Pasette
              Participants:
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: