Oracle SQL Explain Plan	May 5, 2006 10:58:41 AM GMT+05:30

Target:

	Version: Oracle 9.2.0.7.0
	Database: DEV13
	Schema: PRATAPZ
	Date: 05-May-06 5:30:00 AM

SQL Statement:

SELECT o.object_id, o1.object_id FROM obj o, obj1 o1 WHERE o.object_id = o1.object_id

Optimizer Mode Used:

COST ALL ROWS (optimizer: CHOOSE)

Total Cost:

2

Execution Steps:

Step #	Step Name

4

SELECT STATEMENT

3

NESTED LOOPS

1

PRATAPZ.FK_OBJ1 INDEX [FAST FULL SCAN]

2

PRATAPZ.PK_OBJ INDEX [UNIQUE SCAN]

Step #	Description	Est. Cost	Est. Rows Returned	Est. KBytes Returned

1

This plan step retrieves all of the ROWIDs of B*-tree index FK_OBJ1 by sequentially scanning the leaf nodes.

2

1,592

4.664

2

This plan step retrieves a single ROWID from the B*-tree index PK_OBJ.

--

1

0.005

3

This plan step joins two sets of rows by iterating over the driving, or outer, row set (the first child of the join) and, for each row, carrying out the steps of the inner row set (the second child). Corresponding pairs of rows are tested against the join condition specified in the query's WHERE clause.

2

1,592

12.438

4

This plan step designates this statement as a SELECT statement.

2

1,592

12.438