explain plan explaination
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: explain plan explaination

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    explain plan explaination

    DBAs,

    I came across an explain plan like this:
    Code:
    Plan Table 
    ------------------------------------------------------------------------------------------------------------ 
    | Operation                  |  Name    |  Rows | Bytes|  Cost  |  TQ  |IN-OUT| PQ Distrib | Pstart| Pstop | 
    ------------------------------------------------------------------------------------------------------------ 
    | SELECT STATEMENT           |          |     1 |   51 |      3 |      |      |            |       |       | 
    |  HASH JOIN                 |          |     1 |   51 |      3 | 2,02 | P->S |QC (RANDOM) |       |       | 
    |   PARTITION RANGE ITERATOR |          |       |      |        | 2,02 | PCWP |            |     4 |     5 | 
    |    TABLE ACCESS FULL       |EMP_RANGE |     3 |   87 |      1 | 2,00 | PCWP |            |     4 |     5 | 
    |    TABLE ACCESS FULL       |DEPT      |    21 |  462 |      1 | 2,01 | P->P |PART (KEY)  |       |       | 
    ------------------------------------------------------------------------------------------------------------
    What do all these columns like TQ, IN-OUT,PQ Distrib mean?
    There is any link or documentation to explain all these columns?

    Thanks,
    Last edited by marist89; 01-30-2006 at 04:26 PM. Reason: put code tags in

  2. #2
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width