2-2-3. BUFFERS

-- [SQL-2-2-3-a] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT t1.* FROM startdbpg.tr_ord t1 WHERE t1.ord_no BETWEEN 3001 AND 3100;

-- [SQL-2-2-3-b] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT t1.* ,t2.* FROM startdbpg.tr_ord t1 INNER JOIN startdbpg.ms_mbr t2 ON (t2.mbr_id = t1.mbr_id) WHERE t1.ord_no BETWEEN 10 AND 30 ORDER BY t2.nick_nm DESC;

-- [SQL-2-2-3-1-a] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT t1.* FROM startdbpg.tr_ord_big t1 WHERE t1.ord_dtm >= '2019-01-01'::date AND t1.ord_dtm < '2021-01-01'::date;