Oracle Corporation
EFFICIENT OPTIMIZATION OF SQL QUERIES HAVING SET OPERATORS WITH A MULTI-SET SEMANTIC

Abstract:

Disclosed is a system, method, and computer program product to efficiently process multi-set operations in a database system. An approach is described to perform a group-by operation with a counter to efficiently process such queries. Techniques are described to optimize multi-set operations into regular-set operations.