SQL Performance (MOSC)

MOSC Banner

reading sql plan

edited Nov 19, 2016 12:00AM in SQL Performance (MOSC) 3 commentsAnswered

dear all,

I have question about reading sql plan:

SQL> select * from employees e, departments d where e.department_id = d.department_id ;106 rows selected.Execution Plan----------------------------------------------------------Plan hash value: 1901596505--------------------------------------------------------------------------------------------------| Id  | Operation                    | Name              | Rows  | Bytes | Cost (%CPU)| Time     |--------------------------------------------------------------------------------------------------|   0 | SELECT STATEMENT             |                   |   106 |  9540 |     9  (12)| 00:00:01 ||   1 |  MERGE JOIN                  |                   |   106 |  9540 |     9  (12)| 00:00:01 ||   2 |   TABLE ACCESS BY INDEX ROWID| EMPLOYEES         |   107 |  7383 |     2   (0)| 00:00:01 ||   3 |    INDEX FULL SCAN           | EMP_DEPARTMENT_IX |   106 |       |     1   (0)| 00:00:01 ||*  4 |   SORT JOIN                  |                   |    27

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center