Вот что висит в базе:
Код:
Index Fast Full Scan: SUPERMAG.FFSPEC: 162940 out of 162940 Blocks done
Table Scan: SUPERMAG.FFPRODOUTSPEC: 75383 out of 75383 Blocks done
Table Scan: SUPERMAG.FFPRODOUTSPEC: 75383 out of 75383 Blocks done
Table Scan: SUPERMAG.SMSTOCKLEVELS: 10103 out of 10103 Blocks done
Table Scan: SUPERMAG.SMSTOCKLEVELS: 10103 out of 10103 Blocks done
и в нескольких сессиях запрос:
Код:
SELECT s.docid, s.doctype, 0 isincome, s.createdat, s.specitem, s.article,
s.quantity * 1000, s.totalsum
FROM supermag.ffprodoutspec s
WHERE s.createdat BETWEEN to_date('20081014', 'YYYYMMDD') AND to_date(
'20110322', 'YYYYMMDD')
AND s.storeloc = :v00001
AND s.zoneid = :v00002
AND s.article = :v00003
ORDER BY s.createdat, decode(s.doctype, 'PD', 0, 'PO', 2, 3), s.docid,
s.specitem