-
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
-