3-4-5. 테이블 접근과 성능

-- [SQL-3-4-5-a] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT t1.ord_no ,t1.mbr_id ,t1.shop_id FROM startdbpg.tr_ord_big t1 WHERE t1.ord_no BETWEEN 1 AND 10;

-- [SQL-3-4-5-b] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT t1.ord_no, t1.mbr_id, t1.shop_id FROM startdbpg.tr_ord_big t1 WHERE t1.ord_no BETWEEN 1 AND 10000;

[SQL-3-4-5-c] EXPLAIN (COSTS OFF) SELECT t1.ord_no, t1.mbr_id, t1.shop_id FROM startdbpg.tr_ord_big t1 WHERE t1.ord_no BETWEEN 1 AND 20000000;