Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PLAN_TABLE_OUTPUT
- --------------------------------------------------------------------------------
- --------------------------------------------------------------------------------
- -
- | Id | Operation | Name | Rows | Bytes | Cost
- |
- --------------------------------------------------------------------------------
- -
- | 0 | SELECT STATEMENT | | 1 | 14 | 3080
- PLAN_TABLE_OUTPUT
- --------------------------------------------------------------------------------
- |
- | 1 | SORT AGGREGATE | | 1 | 14 |
- |
- | 2 | TABLE ACCESS BY INDEX ROWID| CLAIM_KEY | 6531 | 91434 | 3080
- |
- | 3 | INDEX SKIP SCAN | I_CLAIM_KEY_001 | 1306K| | 2813
- |
- PLAN_TABLE_OUTPUT
- --------------------------------------------------------------------------------
- --------------------------------------------------------------------------------
- -
- Note: cpu costing is off, PLAN_TABLE' is old version
- 11 rows selected.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement