Home » Other » Test » execution plan format test
execution plan format test [message #589392] Fri, 05 July 2013 03:41 Go to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

with courier font:


PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------


-------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name              | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                   |     1 |    52 |     5  (20)| 00:00:01 |
|*  1 |  TABLE ACCESS BY INDEX ROWID| EMPLOYEES         |     1 |    26 |     1   (0)| 00:00:01 |
|   2 |   NESTED LOOPS              |                   |     1 |    52 |     5  (20)| 00:00:01 |
|   3 |    VIEW                     | VW_SQ_1           |     1 |    26 |     4  (25)| 00:00:01 |
|*  4 |     FILTER                  |                   |       |       |            |          |
|   5 |      HASH GROUP BY          |                   |     1 |    10 |     4  (25)| 00:00:01 |
|   6 |       TABLE ACCESS FULL     | EMPLOYEES         |   107 |  1070 |     3   (0)| 00:00:01 |
|*  7 |    INDEX RANGE SCAN         | EMP_DEPARTMENT_IX |    10 |       |     0   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------




with default font:

-------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name              | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                   |     1 |    52 |     5  (20)| 00:00:01 |
|*  1 |  TABLE ACCESS BY INDEX ROWID| EMPLOYEES         |     1 |    26 |     1   (0)| 00:00:01 |
|   2 |   NESTED LOOPS              |                   |     1 |    52 |     5  (20)| 00:00:01 |
|   3 |    VIEW                     | VW_SQ_1           |     1 |    26 |     4  (25)| 00:00:01 |
|*  4 |     FILTER                  |                   |       |       |            |          |
|   5 |      HASH GROUP BY          |                   |     1 |    10 |     4  (25)| 00:00:01 |
|   6 |       TABLE ACCESS FULL     | EMPLOYEES         |   107 |  1070 |     3   (0)| 00:00:01 |
|*  7 |    INDEX RANGE SCAN         | EMP_DEPARTMENT_IX |    10 |       |     0   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------



Still looks ugly....

[Updated on: Fri, 05 July 2013 03:43]

Report message to a moderator

Re: execution plan format test [message #589394 is a reply to message #589392] Fri, 05 July 2013 04:06 Go to previous messageGo to next message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
The default font for code tags is courier and it looks perfectly fine to me.
Re: execution plan format test [message #589395 is a reply to message #589394] Fri, 05 July 2013 04:11 Go to previous message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member

Oh, cookiemonster. It's my web browser font setting issue.
Thanks. Smile
Previous Topic: creating packages using oracle
Next Topic: Split Test 1
Goto Forum:
  


Current Time: Sat Sep 20 19:47:58 CDT 2014

Total time taken to generate the page: 0.10248 seconds