SET autotrace off

EXPLAIN plan FOR
SELECT *
FROM customer
WHERE birthday = TO_DATE('08.08.1972', 'DD.MM.YYYY')

DELETE plan_table;

SELECT *
FROM plan_table

-- plan z plan_table
SELECT substr (lpad(' ', level-1) || operation ||
  ' (' || options || ')',1,30 ) "Operation",
  object_name "Object", "COST" "Cost",
  cpu_cost "CPU Cost"
FROM PLAN_TABLE
START WITH id = 0
CONNECT BY prior id=parent_id;

-- pocet bloku
SELECT blocks FROM user_segments
  WHERE segment_name = 'CUSTOMER';

-- indexy tabulky
SELECT index_name FROM user_indexes
  WHERE TABLE_NAME='CUSTOMER';

-- parametry indexu
SELECT index_name, blevel, leaf_blocks FROM user_indexes
  WHERE TABLE_NAME='CUSTOMER';