|
-- Create table
create table TEST_PART
(
ID NUMBER,
NAME VARCHAR2(5)
)
partition by range (ID)
(
partition P1 values less than (2) ,
partition P2 values less than (3) ,
partition P3 values less than (4)
);
insert into test_part select 1,'***' from dba_objects where rownum<100;
insert into test_part select 2,'***' from dba_objects where rownum<100;
insert into test_part select 3,'***' from dba_objects where rownum<100;
SQL> select * from test_part where id=1;
99 rows selected.
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=99 Bytes=594)
1 0 TABLE ACCESS (FULL) OF 'TEST_PART' (Cost=2 Card=99 Bytes=5
94)
SQL> select * from test_part partition(p1);
99 rows selected.
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=99 Bytes=594)
1 0 TABLE ACCESS (FULL) OF 'TEST_PART' (Cost=2 Card=99 Bytes=5
94)
SQL> select * from test_part partition(p1);
99 rows selected.
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=99 Bytes=594)
1 0 TABLE ACCESS (FULL) OF 'TEST_PART' (Cost=2 Card=99 Bytes=5
94)
SQL> select * from test_part partition(p1);
99 rows selected.
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=99 Bytes=594)
1 0 TABLE ACCESS (FULL) OF 'TEST_PART' (Cost=2 Card=99 Bytes=5
94)
一样的 |
|