慢SQL，求性能优化方法

[bsh614]

一个简单的关联查询，成了慢SQL，麻烦各位大神看看如何优化
EXPLAIN SELECT
SUM(t0.AMOUNTPRINCIPAL),
SUM(t0.AMOUNTINTEREST)
FROM
TB_INVEST_REPAYMENT t0,
TB_INVEST t1
WHERE
t0. STATUS IN ('UNDUE', 'OVERDUE', 'BREACH')
AND t1.ID = t0.INVEST_ID AND t1.USERID = '00000B8B-A62B-4B0D-AAFE-65E7F17A8F84'

执行计划：

[cdutfly]

表结构有没有？贴出来看看

[大雨将至]

试试改成用t0表和 (select ID from TB_INVEST where USERID = '00000B8B-A62B-4B0D-AAFE-65E7F17A8F84') t2 关联 给USERID建索引

[ACMAIN_CHM]

以文本方式贴出 explain select ... show index from .. 以供分析。

[生命沉思者]

如果TB_INVEST.USERID这列的重复值低，给TB_INVEST.USERID这列建索引。