1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| SQL> select * from t1 where n3=10;
N1 N2 N3 F DAT1
---------- ---------- ---------- - --------
11 1 10 Y 11/01/22
SQL> @xpsimp
SQL_ID bxawy4mb85hss, child number 0
-------------------------------------
select * from t1 where n3=10
Plan hash value: 3617692013
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 1086 (100)| |
|* 1 | TABLE ACCESS FULL| T1 | 1 | 23 | 1086 (2)| 00:00:01 |
--------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter("N3"=10)
SQL> create index t1_idx_n3 on t1(n3);
Index created.
SQL> @gvsql
Enter value for sql_id: bxawy4mb85hss
SQL_ID CHILD_NUMBER B B EXECUTIONS END_FETCH INVALIDATIONS OBJECT_STA
------------- ------------ - - ---------- ---------- ------------- ----------
bxawy4mb85hss 0 N N 1 1 2 INVALID_UNAUTH
SQL> select * from t1 where n3=10;
N1 N2 N3 F DAT1
---------- ---------- ---------- - --------
11 1 10 Y 11/01/22
SQL> @xpsimp
SQL_ID bxawy4mb85hss, child number 0
-------------------------------------
select * from t1 where n3=10
Plan hash value: 3886713857
-------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 4 (100)| |
| 1 | TABLE ACCESS BY INDEX ROWID BATCHED| T1 | 1 | 23 | 4 (0)| 00:00:01 |
|* 2 | INDEX RANGE SCAN | T1_IDX_N3 | 1 | | 3 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("N3"=10)
SQL> @gvsql
Enter value for sql_id: bxawy4mb85hss
SQL_ID CHILD_NUMBER B B EXECUTIONS END_FETCH INVALIDATIONS OBJECT_STA
------------- ------------ - - ---------- ---------- ------------- ----------
bxawy4mb85hss 0 N N 1 1 2 VALID |
Partager