Insert data from a non-replicated database

LIMIT ALL

RANDOMO

A & C

B & C

The query plan will show a double redistribute for both tables CUSTOMER and ORDERS followed by a HashJoinNode to compare all rows

The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using a HashJoinNode

The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode

The query plan will show a redistribute for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode

Pluggable Authentication Module (PAM)

Generic Security Services API (GSSAPI)

Simple Authentication and Security Layer (SASL)

Berkeley Software Distribution Authentication (BSDAuth)

Serializable

Committed read

Repeatable read

Uncommitted read

1

2

4

8