如何提高以下select语句执行速度

[三色]

select sum(out_put) from eqp_output where area='1SMOD' and step like '1SM05%' and out_date='2009-3-10'
select sum(qty) from defect where area='1SMOD' and step like '1SM05%' and defect_date='2009-3-10'
select sum(out_put) from eqp_output where area='1SMOD' and step like '1SM05%' and out_date='2009-3-10' and product like 'MODEL%'
select sum(qty) from defect where area='1SMOD' and step like '1SM05%' and defect_date='2009-3-10' and product like 'MODEL%'
select DESCRIPTION ,sum(qty) as quanty from defect where area='1SMOD' and step like '1SM05%' and defect_date='2009-3-10' and product like 'MODEL%' group by DESCRIPTION order by quanty desc

以上语句如何提高速度？
在eqp_output上我已经创建了2个索引，1个包含area/step/out_date，另一个包含area/step/out_date/product
在defect上我已经创建了2个索引，1个包含area/step/defect_date，另一个包含area/step/defect_date/product

[dawugui]

你是五个独立的语句,要干嘛?

请给出表结构，测试数据，具体算法和结果，谢谢。

[sensenyuan]

这应该是最快的了吧！！
就算什么都知道了，对于后面的条件限制，也不可能再简化了！！

[三色]

我是VB里面执行SQL语句的，select语句返回结果在VB程序里用的，

defect的表结构
PROCESS varchar 32 1
PRODUCT varchar 20 1
STEP varchar 16 1
STEPDESC varchar 128 1
AREA varchar 16 1
EQPID varchar 128 1
CELLID varchar 16 1
LOTTYPE varchar 16 1
DEFECT_TIME datetime 8 1
DEFECT_DATE datetime 8 1
OP varchar 64 1
TYPE varchar 16 1
QTY int 4 1
CODE varchar 16 1
DESCRIPTION varchar 128 1
INLINE varchar 128 1
BININFO varchar 128 1
REWORKINFO varchar 16 1
COMMENTDESC varchar 128 1
PART varchar 16 1
SHIFT varchar 8 1


eqp_output的表结构：
PROCESS varchar 50 1
PRODUCT varchar 20 1
STEP varchar 16 1
EQPTYPE varchar 128 1
EQPID varchar 128 1
OUT_PUT int 4 1
OUT_DATE datetime 8 1
OUT_TIME datetime 8 1
PART varchar 16 1
SHIFT varchar 8 1
AREA varchar 16 1

[dawugui]

如果是独立的,看不来还需要怎么改了,帮顶.