Oracle: TABLE ACCESS FULL with Primary key?
- by tim
There is a table:
CREATE TABLE temp
(
IDR decimal(9) NOT NULL,
IDS decimal(9) NOT NULL,
DT date NOT NULL,
VAL decimal(10) NOT NULL,
AFFID decimal(9),
CONSTRAINT PKtemp PRIMARY KEY (IDR,IDS,DT)
)
;
SQL>explain plan for select * from temp;
Explained.
SQL> select plan_table_output from…
