Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PLAN_TABLE_OUTPUT
- --------------------------------------------------------------------------------
- Plan hash value: 1379669967
- --------------------------------------------------------------------------------
- ---------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time
- | Pstart| Pstop |
- --------------------------------------------------------------------------------
- ---------------------
- PLAN_TABLE_OUTPUT
- --------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 1473K| 559M| 284K (1)| 00:56
- :58 | | |
- | 1 | PARTITION LIST ALL| | 1473K| 559M| 284K (1)| 00:56
- :58 | 1 | 57 |
- |* 2 | TABLE ACCESS FULL| GOOGLE_KEYWORD | 1473K| 559M| 284K (1)| 00:56
- :58 | 1 | 57 |
- --------------------------------------------------------------------------------
- ---------------------
- PLAN_TABLE_OUTPUT
- --------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 2 - filter(LOWER("TEXT") LIKE '% holiday inn %' OR LOWER("TEXT") LIKE 'holida
- y inn' OR
- LOWER("TEXT") LIKE 'holiday inn %')
- 15 rows selected.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement