SQL Plan Management 3.0: improve the usability

[zz-jason]

Description

P0 Task List:

• support create binding for update/delete/insert queries #15827 support SQL Bind for more types of SQL statements, like INSERT/UPDATE/DELETE

P1 Tasks List:

• add filters for SPM baseline capture functionality #15655 filter-based baseline capturing

Others:

• draft a proposal about how to support different plan for different parameters in SPM #15074 selectivity-based binding choosing
• filter-based SQL rejection or limitation, reject to execute some SQL
• filter-based plan cache, only cache the matched SQL's execution plan

Progress Tracking: SIG Planner Kanban

Category

Feature, Stability, Performance, Usability,

Value

• Filter-based SQL rejection or limitation can provide quick workaround about big queries.
• Filter-based plan cache can provide a more specific plan cache strategy, reduce the memory consumption caused by caching unnecessary queries, improves the plan cache hit ratio by caching specific queries.
• Support SQL Bind for more types of SQL statements provides a quick workaround for slow INSERT/UPDATE/DELETE queries caused by inefficient plan.

Value Score: 5

Workload Estimation

Workload contains coding, documenting, and testing.
1 Point for 1 Person/Work Day

• 45 Points

Time

GanttStart: 2020-10-01
GanttDue: 2020-11-20