# SQL调优案例
[案例：选择合适的分布列](https://support.huaweicloud.com/devg-911-dws/dws_04_0475.html)
:
[案例：建立合适的索引](https://support.huaweicloud.com/devg-911-dws/dws_04_0476.html)
:
[案例：增加JOIN列非空条件](https://support.huaweicloud.com/devg-911-dws/dws_04_0477.html)
:
[案例：典型不下推语句整改案例集](https://support.huaweicloud.com/devg-911-dws/dws_04_0478.html)
:
[案例：设置cost_param对查询性能优化](https://support.huaweicloud.com/devg-911-dws/dws_04_0479.html)
:
[案例：调整局部聚簇键](https://support.huaweicloud.com/devg-911-dws/dws_04_0481.html)
:
[案例：调整中间表存储方式](https://support.huaweicloud.com/devg-911-dws/dws_04_0482.html)
:
[案例：改建分区表](https://support.huaweicloud.com/devg-911-dws/dws_04_0484.html)
:
[案例：调整GUC参数best_agg_plan](https://support.huaweicloud.com/devg-911-dws/dws_04_0485.html)
:
[案例：改写SQL排除剪枝干扰](https://support.huaweicloud.com/devg-911-dws/dws_04_0488.html)
:
[案例：改写SQL消除in-clause](https://support.huaweicloud.com/devg-911-dws/dws_04_0489.html)
:
[案例：使用partial cluster key](https://support.huaweicloud.com/devg-911-dws/dws_04_0490.html)
:
[案例：NOT IN转NOT EXISTS](https://support.huaweicloud.com/devg-911-dws/dws_04_1000.html)
: