Skip to content

Instantly share code, notes, and snippets.

@wmene

wmene/gist:11301884

Created April 25, 2014 20:18
Show Gist options
  • Save wmene/11301884 to your computer and use it in GitHub Desktop.
Save wmene/11301884 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 3966 | 1177K| 5188 |
| 1 | SORT ORDER BY | | 3966 | 1177K| 5188 |
| 2 | HASH JOIN | | 3966 | 1177K| 4927 |
| 3 | INLIST ITERATOR | | | | |
| 4 | INDEX RANGE SCAN | IDX$$_095F0001 | 4105 | 236K| 245 |
| 5 | HASH JOIN | | 3900 | 933K| 4681 |
| 6 | INLIST ITERATOR | | | | |
| 7 | INDEX RANGE SCAN | IDX$$_095F0001 | 3970 | 228K| 237 |
| 8 | HASH JOIN | | 3858 | 700K| 4443 |
| 9 | INLIST ITERATOR | | | | |
| 10 | INDEX RANGE SCAN | IDX$$_095F0001 | 3721 | 214K| 221 |
| 11 | HASH JOIN | | 4072 | 505K| 4222 |
| 12 | VIEW | index$_join$_001 | 3991 | 265K| 3932 |
| 13 | HASH JOIN | | | | |
| 14 | INDEX RANGE SCAN | IDX$$_095F0001 | 3991 | 265K| 237 |
| 15 | INDEX FAST FULL SCAN| SYS_C0017270 | 3991 | 265K| 4615 |
| 16 | INLIST ITERATOR | | | | |
| 17 | INDEX RANGE SCAN | IDX$$_095F0001 | 4875 | 280K| 289 |
--------------------------------------------------------------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment