Home » RDBMS Server » Performance Tuning » What does it signifies (Oracle9i)
What does it signifies [message #345674] Thu, 04 September 2008 07:31 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
-------------------------------------------------------------------------------------------------
| Id  | Operation                         |  Name                       | Rows  | Bytes | Cost  |
-------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                  |                             |     1 |    70 |   874 |
|   3 |  TEMP TABLE TRANSFORMATION        |                             |       |       |       |
|   1 |   RECURSIVE EXECUTION             | SYS_LE_3_0                  |       |       |       |
|   0 |    INSERT STATEMENT               |                             |  1643 | 31217 |   861 |
|   1 |     LOAD AS SELECT                |                             |       |       |       |
|   2 |      TABLE ACCESS FULL            | ORDER_ITEM          		|  1643 | 31217 |   861 |
|   2 |   RECURSIVE EXECUTION             | SYS_LE_3_1                  |       |       |       |

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
|   0 |    INSERT STATEMENT               |                             |  1990K|    45M|   151K|
|   1 |     LOAD AS SELECT                |                             |       |       |       |
|   2 |      TABLE ACCESS FULL            | ITEM				        |  1990K|    45M|   151K|
|   4 |   SORT GROUP BY                   |                             |     1 |    70 |       |
|   5 |    TABLE ACCESS BY INDEX ROWID    | TRANSFER_DATA_TBL	        |     1 |    18 |     4 |
|   6 |     NESTED LOOPS                  |                             |     1 |    70 |   874 |
|   7 |      NESTED LOOPS                 |                             |     1 |    52 |   870 |
|   8 |       NESTED LOOPS                |                             |     1 |    43 |   868 |
|   9 |        TABLE ACCESS FULL          | COMMUNICATION_ITEM          |     1 |    19 |   861 |
|  10 |        TABLE ACCESS BY INDEX ROWID| ITEM				        |     1 |    24 |     7 |
|  11 |         INDEX RANGE SCAN          | PK_ITEM				        |     4 |       |     3 |


3-TEMP TABLE TRANSFORMATION
1-RECURSIVE EXECUTION
0-INSERT STATEMENT
1- LOAD AS SELECT


What does it signifies?
Regards,
Oli
Re: What does it signifies [message #345677 is a reply to message #345674] Thu, 04 September 2008 07:34 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Are you going to show us the SQL?
Previous Topic: Function Based Join Without Nested Loops
Next Topic: Query to check that statistics gathered
Goto Forum:
  


Current Time: Wed Dec 07 12:54:54 CST 2016

Total time taken to generate the page: 0.05749 seconds