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
|
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> SELECT
2 m.libelle_modele
3 ,v.id_modele
4 FROM
5 vehicule v
6 , modele m
7 WHERE
8 m.id_modele = v.id_modele;
284 rows selected.
SQL> start c:\dispcursor
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------
SQL_ID g6aft1zu1y1a4, child number 0
-------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | OMem | 1Mem | Used-Mem |
--------------------------------------------------------------------------------------------------------------------------------
| 1 | MERGE JOIN | | 1 | 284 | 284 |00:00:00.01 | 5 | | | |
| 2 | TABLE ACCESS BY INDEX ROWID| MODELE | 1 | 23 | 23 |00:00:00.01 | 4 | | | |
| 3 | INDEX FULL SCAN | MOD_PK | 1 | 23 | 23 |00:00:00.01 | 2 | | | |
|* 4 | SORT JOIN | | 23 | 284 | 284 |00:00:00.01 | 1 | 22528 | 22528 |20480 (0)|
| 5 | INDEX FULL SCAN | VEH_IND_FK | 1 | 284 | 284 |00:00:00.01 | 1 | | | |
--------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
4 - access("M"."ID_MODELE"="V"."ID_MODELE")
filter("M"."ID_MODELE"="V"."ID_MODELE")
SQL> SELECT v.id_vehicule,
2 (SELECT m.libelle_modele FROM modele m WHERE m.id_modele = v.id_modele)
3 FROM vehicule v;
284 rows selected.
SQL> start c:\dispcursor
PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------------------
SQL_ID duw0m50jczzt6, child number 0
Plan hash value: 542114372
--------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers |
--------------------------------------------------------------------------------------------------
| 1 | TABLE ACCESS BY INDEX ROWID| MODELE | 23 | 1 | 23 |00:00:00.01 | 25 |
|* 2 | INDEX UNIQUE SCAN | MOD_PK | 23 | 1 | 23 |00:00:00.01 | 2 |
| 3 | TABLE ACCESS FULL | VEHICULE | 1 | 284 | 284 |00:00:00.01 | 16 |
--------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("M"."ID_MODELE"=:B1) |
Partager