Technical Blog

Set Operations CONCATENATION Merges multiple result sets in the same way as in an explicit UNION statement. This typically occurs...

Partition Operations SINGLE Accesses a single partition     D escribes partition boundaries applicable to a single partitioned ob...

Join Operations OUTER An outer join that returns rows from one of the tables, even if there is no matching row in the othe...