|
В InventTable_ds.executeQuery()
SELECT * FROM InventTable USING INDEX ItemIdx WHERE ((ItemType = 0) OR (ItemType = 1) OR (ItemType = 100) OR (ItemType = 2)) EXISTS JOIN * FROM InventItemRangeRef WHERE InventTable.ItemRangeIdRef = InventItemRangeRef.RangeIdRef JOIN * FROM InventItemRangeRef_Retail WHERE InventTable.ItemRangeIdRef_Retail = InventItemRangeRef_Retail.RangeIdRef
В InventSum_ds.executeQuery()
SELECT WITH FORCE_PLACEHOLDERS INDEXISHINT SUM(PostedQty), SUM(PostedValue), SUM(PhysicalValue), SUM(Deducted), SUM(Registered), SUM(Received), SUM(Picked), SUM(ReservPhysical), SUM(ReservOrdered), SUM(OnOrder), SUM(Ordered), SUM(Arrived), SUM(QuotationReceipt), SUM(QuotationIssue), SUM(PhysicalInvent), SUM(PostedValueSecCur_RU), SUM(PhysicalValueSecCur_RU), SUM(AvailPhysical), SUM(AvailOrdered) FROM InventSum GROUP BY InventSum.ItemId ASC USING INDEX ClosedItemDimIdx WHERE ((Closed = 0)) AND ((NOT (AvailPhysical = 0))) AND InventTable.ItemId=InventSum.ItemId JOIN INDEXISHINT * FROM InventDim GROUP BY InventDim.configId ASC, InventDim.InventSizeId ASC, InventDim.InventColorId ASC USING INDEX DimIdIdx WHERE InventSum.InventDimId = InventDim.inventDimId EXISTS JOIN * FROM InventLocation WHERE InventDim.InventLocationId = InventLocation.InventLocationId AND ((InventLocationType = 0) OR (InventLocationType = 101)) AND ((InventLocationId = N'Ц_СБ_ОСН'))
Записи в InventSum фильтруются, а связанная с ней по Delayed
запись InventTable не фильтруется
|