Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: TIDB 后续是否实现 执行计划缓存 功能
Will future versions implement the execution plan caching feature? For example, both Oracle and Oceanbase have this feature.
No, this is for prepared statements, similar to this.
This? (Non-Prepared Statement Execution Plan Cache)
Non-prepared statements can also be cached; it just depends on whether you think caching is worthwhile.
This will probably come gradually.
There is now, but each time the parsing doesn’t work very well.
Non-prepared plan cache is already supported, and there are plans to extend this support to the instance level (currently it is at the session level). All of this is on the roadmap.