大乌龟 李冰 邹建在不在 等等知道的告诉我啊这个同样SQL 执行计划为何不一样
utpcb 2009-10-26 04:04:59 语句是
select CAST(0 as bit)
checksta,'未发送' sta
from
(Select * from FKTransaction2 Where TransactionNO < LinkNO and LinkNO <> '' and delmark='0' ) a,
(Select * from FKTransaction2 Where (LinkNO <> '' and delmark='0') and (LinkNO < TransactionNO)) b,
FKCounterParty c
where a.TransactionNO=b.LinkNO and a.direct like '%回购' and a.CounterParty=c.CounterPartyId and
((a.TradeDate>='20090526' and a.TradeDate<='20090526') or
(b.TradeDate>='20090526' and b.TradeDate<='20090526')) and
a.account in (15,18,27,14,29,30,31,32,33,28,7,8,9,10,11,12,25,26,20,21,22,24)
执行计划不同 我想问一下同一个机器不同窗口或者相同窗口考来的一样SQL 速度(执行计划不一样)不一样