need to understand the execution plan of a query
Hello ,
Please refer to the below execution plan.Please advise why these extra fields are coming in execution plan(Pstart,Pstop,TQ,IN-OUT and PQDistrib)and what does this mean?
Execution Plan
| Id | Operation | Name | Rows | Bytes | Cost (%CPU) | Time | Pstart | Pstop | TQ | IN-OUT | PQ Distrib | 
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | UPDATE STATEMENT | 81240 (100) | |||||||||
| 1 | UPDATE | F_ENGAGEMENT_PERSON | |||||||||
| 2 | PX COORDINATOR | ||||||||||
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 145 | 6815 | 81240 (2) | 00:18:58 | Q1,00 | P->S | QC (RAND) | ||
| 4 | PX BLOCK ITERATOR | 145 | 6815 | 81240 (2) | 00:18:58 | 1 | 229 | Q1,00 | PCWC | ||
| 5 | TABLE ACCESS FULL | F_ENGAGEMENT_PERSON | 145 | 6815 | 81240 (2) | 00:18:58 | 1 | 229 | Q1,00 | PCWP | 
Back to Plan 1(PHV: 1931325571) 
Back to Top 
Full SQL Text
0