Which two are true regarding the execution plan?
A.
The CUSTOMERS table is hash partitioned.
B.
The SALES table is hash partitioned.
C.
The CUSTOMERS table is scanned first and selected partitions from the SALES table are
scanned based on the BLOOM Filter created during the scan of the CUSTOMERS table.
D.
The SALES table is scanned first and selected partitions from the CUSTOMERS table are
scanned based on the Bloom Filter created during the scan of the SALES table.
E.
Both the CUSTOMERS and SALES tables are scanned simultaneously and rows from the
CUSTOMERS table are joined to row of the SALES table.
F.
The CUSTOMERS table is range partitioned.
Explanation:
B: As per line 14 and 15.
C: As per exhibit line 13 is execute before line 15.
Incorrect:
Not E: As per line 13 and 15 – they are not executed simultaneously.
Agree with given answers