-- [SQL-6-1-1-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_ord_big T1
WHERE t1.ord_dtm >= '2023-01-01'::date
AND t1.ord_dtm < '2023-02-01'::date
ORDER BY t1.shop_id ,t1.mbr_id;
SQL
복사
-- [SQL-6-1-1-b]
SHOW work_mem;
SQL
복사