А можно увидеть план запроса
Код:
SELECT A . PLU,
B . ARTICLE,
REPLACE(C . NAME, CHR(9), ' ') AS NAME,
0 AS DEP,
SUPERMAG.CLASSIFIER.NORMALIZECLASSIF(SUBSTR(D.TREE,
1,
INSTR(D.TREE, '.'))) AS GROUP_ZN,
SUBSTR(D.TREE, 1, INSTR(D.TREE, '.')) AS TREE,
A . STOREUNIT
FROM SUPERMAG . SLARTSCALEMAP A,
SUPERMAG . SVSTOREUNITS B,
SUPERMAG . SMCARD C,
SUPERMAG.SACARDCLASS D
WHERE (A.LOCID = :P_LOC)
AND A.STATE = 0
AND (A.DEPID = :P_DEP)
AND (A.STOREUNIT = B.BARCODE)
AND (B.ARTICLE = C.ARTICLE)
AND (C.IDCLASS = D.ID)
ORDER BY 4 ASC, 5 ASC, 6 ASC, 3