优化优化!!!!
fdzxb 2004-09-26 11:03:01 数据表ITF_TOTAL才17万数据,执行以下语句平均要10秒左右,对RESULT和
flag做了一个索引,效果不好,请问各位大侠如何优化???
SELECT *
FROM ITF_TOTAL
WHERE ((RESULT='-2' and flag = 0)
or (substr(result,1,1)<>'-' and flag = 0))
and (data_target='CCAT' or data_send='CCAT') and rownum<2