-
Type: New Feature
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: Admin, Diagnostics, Logging, Querying
-
Fully Compatible
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.
- 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.
- is related to
-
SERVER-12358 Add query plan history and logging
- Closed
- related to
-
SERVER-9306 Ability to temporarily forbid query optimizer from using index ("invisible index")
- Closed
-
SERVER-5470 View memorized query optimized plans
- Closed
-
SERVER-666 query optimizer introspection
- Closed
-
SERVER-8692 Add logging to indicate when cached query plan changes
- Closed