Hitachi

Hitachi Advanced Database Application Development Guide


5.8.3 Characteristics of the methods for processing set operations

The following table shows the characteristics of each method for processing set operations.

Table 5‒9: Characteristics of the methods for processing set operations

Methods for processing set operations

Benefits

Disadvantages

Hash execution

Results can be obtained at a higher speed when the data required for the set operation can be stored in the hash table area.

If a shortage occurs in the hash table area due to a large amount of data required for the set operation, processing performance decreases because the data is temporarily saved in a work table.

Work table execution

This method is applicable to all set operations.

If there are a large number of retrieval results, the amount of data stored in the work table becomes large. In this case, processing performance decreases because deduplication is performed after the data stored in the work table is sorted.