Support non-prepared plan cache (Stage 1) #36598
Description
Feature Request
Is your feature request related to a problem? Please describe:
TP queries can get lots of performance benefits from Plan Cache, but the current TiDB Plan Cache can only support Prepare/Execute Statements. Most of our users are still using general queries to access TiDB instead of Prepare/Execute. So if Plan Cache can support general queries, these users can gain some performance benefits as well.
Describe the feature you'd like:
When we execute the general query, we can skip the parser and optimizer phase to directly get the physical plan from the plan cache. That can save more time for the TP queries.
Teachability, Documentation, Adoption, Migration Strategy:
The detail design will be posted later.