Oracleêy?Y?aSQLPLUS?D????3￡ó?setó???(2)

King Executive 1700

Kochhar Executive 1700

De Haan Executive 1700

Hunold IT 1400

Ernst IT 1400?-?-

106 rows selected.

Execution Plan

?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a-

0 SELECT STATEMENT Optimizer=CHOOSE (Cost=5 Card=106 Bytes=318

0)

1 0 HASH JOIN (Cost=5 Card=106 Bytes=3180)

2 1 TABLE ACCESS (FULL) OF ??DEPARTMENTS?ˉ (Cost=2 Card=27 Byt

es=513)

3 1 TABLE ACCESS (FULL) OF ??EMPLOYEES?ˉ (Cost=2 Card=107 Byte

s=1177)

Statistics

?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a?a-

7 recursive calls

0 db block gets

23 consistent gets

12 physical reads

0 redo size

2801 bytes sent via SQL*Net to client

580 bytes received via SQL*Net from client

9 SQL*Net roundtrips to/from client

0 sorts (memory)

0 sorts (disk)

106 rows processed

SQL>