Oracle Live SQL - Script: Session 03

Statement 1

select * from test

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 2

CREATE TABLE TEST  
(pk number,  
MF VARCHAR2(10),  
COLOR VARCHAR2(10),  
WEIGHT NUMBER)  
PARTITION BY LIST(MF)  
(PARTITION MF_A  
VALUES('A'),  
PARTITION MF_B  
VALUES('B')  
)

Table created.

Statement 3

INSERT INTO TEST  
VALUES(1,'A','R',2)

1 row(s) inserted.

Statement 4

SELECT * FROM TEST WHERE MF='A'


PK MF COLOR WEIGHT
1 A R 2

PK	MF	COLOR	WEIGHT
1	A	R	2

Statement 5

INSERT INTO TEST  
VALUES(2,'A','R',2)

1 row(s) inserted.

Statement 6

CREATE TABLE TEST  
(pk number,  
MF VARCHAR2(10),  
COLOR VARCHAR2(10),  
WEIGHT NUMBER)  
PARTITION BY LIST(MF)  
(PARTITION MF_A  
VALUES('A'),  
PARTITION MF_B  
VALUES('B')  
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 7

INSERT INTO TEST  
VALUES(3,'A','R',2) 
 
SELECT * FROM TEST WHERE MF='A'

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 8

INSERT INTO TEST  
VALUES(3,'A','R',2)

1 row(s) inserted.

Statement 9

INSERT INTO TEST  
VALUES(4,'A','Y',20)

1 row(s) inserted.

Statement 10

INSERT INTO TEST  
VALUES(5,'A','Y',21)

1 row(s) inserted.

Statement 11

INSERT INTO TEST  
VALUES(6,'A','Y',221)

1 row(s) inserted.

Statement 12

INSERT INTO TEST  
VALUES(7,'A','Y',221)

1 row(s) inserted.

Statement 13

CREATE TABLE TEST  
(pk number,  
MF VARCHAR2(10),  
COLOR VARCHAR2(10),  
WEIGHT NUMBER)  
PARTITION BY LIST(MF)  
(PARTITION MF_A  
VALUES('A'),  
PARTITION MF_B  
VALUES('B')  
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 14

INSERT INTO TEST  
VALUES(8,'A','Y',221) 
 
SELECT * FROM TEST WHERE MF='A'

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 15

INSERT INTO TEST  
VALUES(8,'A','Y',221)

1 row(s) inserted.

Statement 16

INSERT INTO TEST  
VALUES(9,'A','Y',221)

1 row(s) inserted.

Statement 17

INSERT INTO TEST  
VALUES(10,'A','Y',221)

1 row(s) inserted.

Statement 18

INSERT INTO TEST  
VALUES(11,'B','Y',221)

1 row(s) inserted.

Statement 19

INSERT INTO TEST  
VALUES(12,'B','Y',221)

1 row(s) inserted.

Statement 20

EXPLAIN PLAN FOR SELECT * FROM TEST WHERE MF='A' AND pk>0

Statement processed.

Statement 21

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

Statement 22

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

Statement 23

EXPLAIN PLAN FOR SELECT * FROM TEST WHERE MF='A' AND pk>0

Statement processed.

Statement 24

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 25

CREATE INDEX IDX_TEST ON TEST(pk)

Index created.

Statement 26

EXPLAIN PLAN FOR SELECT * FROM TEST WHERE MF='A' AND pk>0

Statement processed.

Statement 27

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

Statement 28

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

PLAN_TABLE_OUTPUT
Error: cannot fetch last explain plan from PLAN_TABLE

Statement 29

EXPLAIN PLAN FOR SELECT * FROM TEST WHERE MF='A' AND pk>0

Statement processed.

Statement 30

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 2025021737
 
-----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                  | Name     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                           |          |     4 |   160 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE                     |          |     4 |   160 |     3   (0)| 00:00:01 |     2 |     2 |
|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TEST     |     4 |   160 |     3   (0)| 00:00:01 |     2 |     2 |
|*  3 |    INDEX RANGE SCAN                        | IDX_TEST |     1 |       |     1   (0)| 00:00:01 |     2 |     2 |
-----------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

19 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 2025021737

-----------------------------------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-----------------------------------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 4 \| 160 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE \| \| 4 \| 160 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\| 2 \| TABLE ACCESS BY LOCAL INDEX ROWID BATCHED\| TEST \| 4 \| 160 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 3 \| INDEX RANGE SCAN \| IDX_TEST \| 1 \| \| 1 (0)\| 00:00:01 \| 2 \| 2 \|
-----------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - access("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 31

EXPLAIN PLAN FOR SELECT * FROM TEST WHERE MF='B' AND pk>0

Statement processed.

Statement 32

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 2025021737
 
-----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                  | Name     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                           |          |     4 |   160 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE                     |          |     4 |   160 |     3   (0)| 00:00:01 |     2 |     2 |
|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TEST     |     4 |   160 |     3   (0)| 00:00:01 |     2 |     2 |
|*  3 |    INDEX RANGE SCAN                        | IDX_TEST |     1 |       |     1   (0)| 00:00:01 |     2 |     2 |
-----------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

19 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 2025021737

-----------------------------------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-----------------------------------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 4 \| 160 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE \| \| 4 \| 160 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\| 2 \| TABLE ACCESS BY LOCAL INDEX ROWID BATCHED\| TEST \| 4 \| 160 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 3 \| INDEX RANGE SCAN \| IDX_TEST \| 1 \| \| 1 (0)\| 00:00:01 \| 2 \| 2 \|
-----------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - access("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 33

EXPLAIN PLAN FOR SELECT * FROM TEST WHERE MF='B' AND pk>0

Statement processed.

Statement 34

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 2025021737
 
-----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                  | Name     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                           |          |     4 |   160 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE                     |          |     4 |   160 |     3   (0)| 00:00:01 |     2 |     2 |
|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TEST     |     4 |   160 |     3   (0)| 00:00:01 |     2 |     2 |
|*  3 |    INDEX RANGE SCAN                        | IDX_TEST |     1 |       |     1   (0)| 00:00:01 |     2 |     2 |
-----------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

19 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 2025021737

-----------------------------------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-----------------------------------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 4 \| 160 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE \| \| 4 \| 160 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\| 2 \| TABLE ACCESS BY LOCAL INDEX ROWID BATCHED\| TEST \| 4 \| 160 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 3 \| INDEX RANGE SCAN \| IDX_TEST \| 1 \| \| 1 (0)\| 00:00:01 \| 2 \| 2 \|
-----------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - access("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 35

EXPLAIN PLAN FOR SELECT * FROM TEST partition mf_a WHERE  pk>0

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 36

EXPLAIN PLAN FOR SELECT * FROM TEST partition mf_a WHERE  pk>0

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 37

EXPLAIN PLAN FOR SELECT * FROM TEST partition MF_A WHERE  pk>0

ORA-00933: SQL command not properly ended

More Details: https://docs.oracle.com/error-help/db/ora-00933

Statement 38

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0

Statement processed.

Statement 39

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 4170016888
 
-------------------------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |    12 |   480 |     5   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST ALL|      |    12 |   480 |     5   (0)| 00:00:01 |     1 |     2 |
|*  2 |   TABLE ACCESS FULL| TEST |    12 |   480 |     5   (0)| 00:00:01 |     1 |     2 |
-------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 4170016888

-------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 12 \| 480 \| 5 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST ALL\| \| 12 \| 480 \| 5 (0)\| 00:00:01 \| 1 \| 2 \|
\|* 2 \| TABLE ACCESS FULL\| TEST \| 12 \| 480 \| 5 (0)\| 00:00:01 \| 1 \| 2 \|
-------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 40

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='A'

Statement processed.

Statement 41

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 42

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 43

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 4170016888
 
-------------------------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |    12 |   480 |     5   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST ALL|      |    12 |   480 |     5   (0)| 00:00:01 |     1 |     2 |
|*  2 |   TABLE ACCESS FULL| TEST |    12 |   480 |     5   (0)| 00:00:01 |     1 |     2 |
-------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 4170016888

-------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 12 \| 480 \| 5 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST ALL\| \| 12 \| 480 \| 5 (0)\| 00:00:01 \| 1 \| 2 \|
\|* 2 \| TABLE ACCESS FULL\| TEST \| 12 \| 480 \| 5 (0)\| 00:00:01 \| 1 \| 2 \|
-------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 44

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 45

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |     2 |    80 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|*  2 |   TABLE ACCESS FULL   | TEST |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 46

DROP INDEX IDX_TEST

Index dropped.

Statement 47

CREATE INDEX IDX_TEST ON TEST(pk) LOCAL

Index created.

Statement 48

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 49

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |     2 |    80 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|*  2 |   TABLE ACCESS FULL   | TEST |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 50

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 51

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |     2 |    80 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|*  2 |   TABLE ACCESS FULL   | TEST |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 52

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='A'

Statement processed.

Statement 53

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 2025021737
 
-----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                  | Name     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                           |          |     2 |    80 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE                     |          |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TEST     |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|*  3 |    INDEX RANGE SCAN                        | IDX_TEST |     1 |       |     1   (0)| 00:00:01 |     2 |     2 |
-----------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

19 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 2025021737

-----------------------------------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-----------------------------------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\| 2 \| TABLE ACCESS BY LOCAL INDEX ROWID BATCHED\| TEST \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 3 \| INDEX RANGE SCAN \| IDX_TEST \| 1 \| \| 1 (0)\| 00:00:01 \| 2 \| 2 \|
-----------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - access("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 54

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='A'

Statement processed.

Statement 55

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 4170016888
 
-------------------------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |    12 |   480 |     5   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST ALL|      |    12 |   480 |     5   (0)| 00:00:01 |     1 |     2 |
|*  2 |   TABLE ACCESS FULL| TEST |    12 |   480 |     5   (0)| 00:00:01 |     1 |     2 |
-------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 4170016888

-------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 12 \| 480 \| 5 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST ALL\| \| 12 \| 480 \| 5 (0)\| 00:00:01 \| 1 \| 2 \|
\|* 2 \| TABLE ACCESS FULL\| TEST \| 12 \| 480 \| 5 (0)\| 00:00:01 \| 1 \| 2 \|
-------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 56

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='A'

Statement processed.

Statement 57

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 2025021737
 
-----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                  | Name     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                           |          |     2 |    80 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE                     |          |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TEST     |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|*  3 |    INDEX RANGE SCAN                        | IDX_TEST |     1 |       |     1   (0)| 00:00:01 |     2 |     2 |
-----------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

19 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 2025021737

-----------------------------------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-----------------------------------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\| 2 \| TABLE ACCESS BY LOCAL INDEX ROWID BATCHED\| TEST \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 3 \| INDEX RANGE SCAN \| IDX_TEST \| 1 \| \| 1 (0)\| 00:00:01 \| 2 \| 2 \|
-----------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - access("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 58

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='A'

Statement processed.

Statement 59

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 60

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='A'

Statement processed.

Statement 61

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 62

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 63

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 64

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 65

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 66

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 67

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 68

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 2025021737
 
-----------------------------------------------------------------------------------------------------------------------
| Id  | Operation                                  | Name     | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
-----------------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                           |          |     2 |    80 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE                     |          |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|   2 |   TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TEST     |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|*  3 |    INDEX RANGE SCAN                        | IDX_TEST |     1 |       |     1   (0)| 00:00:01 |     2 |     2 |
-----------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

19 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 2025021737

-----------------------------------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
-----------------------------------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\| 2 \| TABLE ACCESS BY LOCAL INDEX ROWID BATCHED\| TEST \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 3 \| INDEX RANGE SCAN \| IDX_TEST \| 1 \| \| 1 (0)\| 00:00:01 \| 2 \| 2 \|
-----------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - access("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 69

DROP INDEX IDX_TEST

Index dropped.

Statement 70

CREATE INDEX IDX_TEST ON TEST(pk)

Index created.

Statement 71

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 72

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 10 \| 400 \| 3 (0)\| 00:00:01 \| 1 \| 1 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 73

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='B'

Statement processed.

Statement 74

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |     2 |    80 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
|*  2 |   TABLE ACCESS FULL   | TEST |     2 |    80 |     3   (0)| 00:00:01 |     2 |     2 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

PLAN_TABLE_OUTPUT
Plan hash value: 213508695

----------------------------------------------------------------------------------------------
\| Id \| Operation \| Name \| Rows \| Bytes \| Cost (%CPU)\| Time \| Pstart\| Pstop \|
----------------------------------------------------------------------------------------------
\| 0 \| SELECT STATEMENT \| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| \| \|
\| 1 \| PARTITION LIST SINGLE\| \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
\|* 2 \| TABLE ACCESS FULL \| TEST \| 2 \| 80 \| 3 (0)\| 00:00:01 \| 2 \| 2 \|
----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

2 - filter("PK">0)

Note
-----
- dynamic statistics used: dynamic sampling (level=2)

Statement 75

EXPLAIN PLAN FOR SELECT * FROM TEST  WHERE  pk>0 AND MF='A'

Statement processed.

Statement 76

select * from TABLE(DBMS_XPLAN.display())


PLAN_TABLE_OUTPUT
Plan hash value: 213508695
 
----------------------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |
----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |    10 |   400 |     3   (0)| 00:00:01 |       |       |
|   1 |  PARTITION LIST SINGLE|      |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
|*  2 |   TABLE ACCESS FULL   | TEST |    10 |   400 |     3   (0)| 00:00:01 |     1 |     1 |
----------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter("PK">0)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=2)

18 rows selected.

Session 03

Additional Information