SQL Server Index Intersection/Union

The SQL Server optimizer has many algorithms and operators to put together reusable execution plans for queries that you run against a system.