帮忙优化下

[liyufu86]

前人写的代码
发现执行起来很慢

高人看看怎么优化

select count( distinct a.id ) from OrderProductItem a where ( a.stauts= 2 and a.orgId= 10000 ) or (a.id in (select a.parentid from a where a.stauts= 0 and a.stauts_deliver= 22 group by a.parentid ))

十分感谢

不知道为什么很慢，

[pt1314917]

--try:
select count( distinct a.id ) from OrderProductItem a ,a t
 where (a.stauts= 2 and a.orgId= 10000 ) or (a.id=t.parentid and t.stauts= 0 and t.stauts_deliver= 22 )

[moonshineidolon]

select count( distinct a.id )

from OrderProductItem a where

( a.stauts= 2 and a.orgId= 10000 ) or

(

a.id in (


select a.parentid from a where a.stauts= 0 and a.stauts_deliver= 22


)

)

[liyufu86]

谢谢楼上的2位，为什么我的那个查询很慢呢

[等不到来世]

select count(distinct id)
from
(
	select id from OrderProductItem where stauts= 2 and orgId= 10000
	union all
	select a.id
	from OrderProductItem a join OrderProductItem b
	on a.id=b.parentid
	where b.stauts=0 and b.stauts_deliver= 22
) t

[等不到来世]

你那个查询应该会运行时报错。

[you_tube]

[Quote=引用 3 楼 liyufu86 的回复:]
谢谢楼上的2位，为什么我的那个查询很慢呢
[/Quote]

select count( distinct a.id ) from OrderProductItem a  where ( a.stauts= 2 and a.orgId= 10000 ) or (a.id in (select a.parentid from a where a.stauts= 0 and a.stauts_deliver= 22 group by a.parentid ))

in这个相当再查询一遍