Oracle Enterprise Manager
 
Oracle SQL Analyze Explain Plan
 

Version: 9.2.0.1.0 production

 

Database: VIZDEV.WORLD

 

Schema: CCDOTTSVR

 

Date: 10/25/2005 11:38:20 AM


SQL Statement -- SQL014:

  

SELECT /*+ INDEX (uln_syn) */
       uln_syn.poe_ald_cal grp0, SUM(uln_syn.sumoftotal_stons) tot0
    FROM uln_syn
    WHERE EXISTS (SELECT ca_keys.comp_key
                      FROM ca_keys
                      WHERE ca_keys.comp_id = 
                            '0x080e00000107235e9e7f0a1428098124'
                        AND uln_syn.tpfdd_runid_uln = ca_keys.comp_key)
    GROUP BY uln_syn.poe_ald_cal

Get Explain Plan By:

   Cost All Rows

Execution Steps:

7 border=0 SELECT STATEMENT
6 border=0 SORT (GROUP BY)
5 border=0 NESTED LOOPS
2 border=0 SORT (UNIQUE)
1 border=0 INDEX (FAST FULL SCAN), CA_KEYS_COMP_ID_KEY_IDX (CCDOTTSVR)
4 border=0 TABLE ACCESS (BY INDEX ROWID), ULN (CCDOTTSVR)
3 border=0 INDEX (UNIQUE SCAN), ULN_PK (CCDOTTSVR)

Step Description Est Cost Est Row Count Est Byte Count
1 This operation retrieves all ROWIDs via a fast full index lookup of CA_KEYS_COMP_ID_KEY_IDX. 5 14958 912438
2 This operation returns the distinct rows from its child row source, in order.
3 This operation retrieves a single ROWID by an index lookup of ULN_PK. 1 1
4 This operation retrieves a row of table ULN based on its ROWID. 2 1 36
5 This operation compares each row of its first child row source with all rows of its second child row source, joining those row pairs for which some condition holds. 15223 14958 1450926
6 This operation returns its child row source sorted into groups based on the columns of the GROUP BY clause. 15354 416 40352
7 This step in the plan designates this statement as a SELECT statement. 15354 416 40352