PX PARTITION LIST ALL performs the operation on all list table partitions after dividing the process between parallel slave processes.
PX PARTITION RANGE ALL performs the operation on all range table partitions after dividing the process between parallel slave processes.
PX RECEIVE retrieves data from rows sent by child processes after dividing the scan process between parallel scan slaves.
Operation: PX SEND
Option: BROADCAST
The PX SEND BROADCAST operation sends rows to the parent process for scanning by parallel scan slaves.
Option: BROADCAST LOCAL
The PX SEND BROADCAST LOCAL operation sends rows to the local parent process for scanning by parallel scan slaves.
Option: HASH
The PX SEND HASH operation sends rows to the parent process for scanning by parallel scan slaves.
Option: PARTITION (KEY)
The PX SEND PARTITION (KEY) operation sends rows based on a partition key to the parent process for scanning by parallel scan slaves.
Option: QC (ORDER)
The PX SEND QC (ORDER) operation sends ordered rows to the queue coordinator process for scanning by parallel scan slaves.
Option: QC (RANDOM)
The PX SEND QC (RANDOM) operation sends random rows to the queue coordinator process for scanning by parallel scan slaves.
Option: RANGE
The PX SEND RANGE operation sends a range of rows to the parent process for scanning by parallel scan slaves.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center