专业版12.2外购入库核算卡，老慢了，如何解决？
核算20行数据，用了10多分钟。。
跟踪到
Select t1.Fitemid,t1.FEntryID,t2.FinterID,t1.FDCStockID,t2.FDate,round(t1.FAmount,2) as FAmount,t3.FHookAmount,t3.FHookQty,t1.FQty,ISNULL(t2.FVchinterID,0) AS FVchinterID,
IsNull((Select top 1 ISNULL(t10.FVchinterID,0) AS FVchinterID From ICStockBill t10 Inner Join ICStockBillEntry t11 On t10.FInterID=t11.FInterID
Where t11.FSourceInterID=t1.FInterID ),0) as FSVchinterID
from ICStockBillEntry t1 INNER JOIN ICStockBill t2 on
t1.FinterID=t2.FinterID INNER JOIN (
Select FIBinterID as FinterID,FEntryID,round(FHookAmount,2) as FHookAmount,FHookQty FROM ICHookrelations WHERE FGroupNO =12895
AND FHookType=0 AND FIBTag=1)t3
ON (t2.FinterID=t3.FinterID AND t1.FEntryID=t3.FEntryID)
Where t2.FTranType=1
这个句语，老慢了，有什么办法处理