HYBRID TSM/HWMB in Explain plan
Ab 12c stellt Oracle im Plan mehr Infos zum internen Space-Management bereit. -------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | TQ |IN-OUT| PQ Distrib | -------------------------------------------------------------------------------------------- | 0 | INSERT STATEMENT | | 39 | | | | | 1 | PX COORDINATOR | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10000 | 39 | Q1,00 | P->S | QC (RAND) | | 3 | LOAD AS SELECT (HYBRID TSM/HWMB)| T1 | | Q1,00 | PCWP | | | 4 | OPTIMIZER STATISTICS GATHERING | | 39 | Q1,00 | PCWP | | | 5 | PX BLOCK ITERATOR | | 39 | Q1,00 | PCWC | | | 6 | TABLE ACCESS FULL | T | 39 | Q1,00 | PCWP