I. When members are basic data types

1. Concatenation

2. Intersection

3. Union

4. Difference

5. XOR

6. Operation on more than two sets: Concatenation

6. Operation on more than two sets: Union & Difference

6. Operation on more than two sets: Intersection

6. Operation on more than two sets: XOR

II. When members are records

1. Reference eligible records directly

2. Merge sets by certain fields

3. Merge sets by the primary key

4. Merge sets by all fields

5. When records are not ordered by the key

III. Big data operations

1. Concatenation of sets

2. Merge sets by column values

Click to download the PDF file