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