Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 建议:执行计划中,CTE和表加上名字,方便看懂
|
username: 华健-梦诚科技
Version: All versions
When the SQL is complex, it takes a long time to find the corresponding relationship with the SQL in the execution plan.
As shown in the figure, it is recommended to add names to the CTE in the id column and to add real names to the table in the access object column (currently only aliases are shown).