|
||||||||||||||||||||
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 | |
|
Cost All Rows |
5 | SELECT STATEMENT |
4 | SORT (GROUP BY) |
3 | HASH JOIN |
1 | INDEX (FAST FULL SCAN), CA_KEYS_COMP_ID_KEY_IDX (CCDOTTSVR) |
2 | 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 |