Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 用户的表在跑做全表扫描。软件提示可以加哪个索引，tidb里面有没有相关功能选项
|
username: tidb狂热爱好者
[Problem Scenario Involved] 1
Regarding intelligent index recommendation. The user’s table is performing a full table scan. The software suggests which index can be added.
Alibaba Cloud’s SQL console has this feature.
The open-source pg database also has it.
First Look at openGauss Index Recommendation (Index-advisor) - Zhihu (zhihu.com)
Entering RDS: RDS PostgreSQL Index Recommendation Principles and Best Practices - Zhihu (zhihu.com)
[Expected Demand Behavior]
I will send a link.
[Alternative Solutions for the Demand]