-- [SQL-6-1-2-a]: work_mem을 늘린 후에 [SQL-6-1-1-a]를 재실행
SET work_mem = '128MB';
-- [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-2-b]
SET work_mem = '4MB';
SQL
복사