-- [SQL-5-2-6-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT /*+ IndexScan(t1 tr_ord_big_x03) */
t1.*
FROM startdbpg.tr_ord_big t1
WHERE t1.mbr_id = 'M00031';
SQL
복사
-- [SQL-5-2-6-b]
SELECT t1.relname ,t1.relpages block_cnt
FROM pg_class t1
WHERE t1.oid = 'startdbpg.tr_ord_big_x03'::regclass;
SQL
복사


