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:37:11 AM


SQL Statement -- SQL013:

  

SELECT uln.poe_ald_cal grp0, SUM(uln.sumoftotal_stons) tot0
    FROM (SELECT ca_keys.comp_key
              FROM ca_keys
              WHERE ca_keys.comp_id = '0x080e00000107235e9e7f0a1428098124') 
         ca_keys, uln
    WHERE uln.tpfdd_runid_uln = ca_keys.comp_key
    GROUP BY uln.poe_ald_cal

Get Explain Plan By:

   Cost All Rows

Execution Steps:

5 border=0 SELECT STATEMENT
4 border=0 SORT (GROUP BY)
3 border=0 HASH JOIN
1 border=0 INDEX (FAST FULL SCAN), CA_KEYS_COMP_ID_KEY_IDX (CCDOTTSVR)
2 border=0 TABLE ACCESS (FULL), ULN (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 retrieves all rows of table ULN using a full table scan. 1767 249395 8978220
3 This operation takes its two child row sources and hashes their join columns to find row pairs which satisfy the join condition. 1971 14958 1450926
4 This operation returns its child row source sorted into groups based on the columns of the GROUP BY clause. 2102 416 40352
5 This step in the plan designates this statement as a SELECT statement. 2102 416 40352