[KpecT]

Данный запрос работает от 7 до 8 мин., сильно долго. Помогииииииииите

while select sum(AmountMST),AccountNum,Dimension[4],Voucher
from
ledgerTrans
index hint ACDate
group by Dimension[4],AccountNum,Voucher
where (ledgerTrans.AccountNum == #Account08_20
|| ledgerTrans.AccountNum == #Account08_30
|| ledgerTrans.AccountNum == #Account08_80
|| ledgerTrans.AccountNum == #Account08_90
|| ledgerTrans.AccountNum == #Account08_91
|| ledgerTrans.AccountNum == #Account08_92)
&& ledgerTrans.TransDate <= transdate
&& ledgerTrans.PeriodCode == PeriodCode::Regular
&& !(ledgerTrans.Voucher like "IV05*")
{
select firstonly firstFast RecId
from
inventTrans
where inventTrans.Voucher == ledgerTrans.Voucher;
if (!inventTrans.RecId)
{
value = ledgerTrans.AmountMST;
b = [ledgerTrans.Dimension[4],ledgerTrans.AccountNum];
simap = this.SetMap(simap,value,b);
}
}