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,