Modified Plans

The information in the following sections in the Microsoft SQL Server Administrator's Companion are changed for SQL Server 6.5:

• EXISTS TABLE: nested iteration
• AND NOT EXISTS: nested iteration
• OR EXISTS: nested iteration
• OR NOT EXISTS: nested iteration
• SUBQUERY: nested iteration
• AND EXISTS: nested iteration
• WITH CHECK OPTION

These sections are replaced with the following modified or new sections:

Modified

• EXISTS TABLE: nested iteration
• NOT EXISTS: nested iteration
• OR EXISTS: nested iteration
• AND EXISTS: nested iteration
• SUBQUERY: nested iteration
• WITH CHECK OPTION

New

• GROUP BY WITH CUBE
• GROUP BY WITH ROLLUP
• LEFT OUTER JOIN: nested iteration
• FULL OUTER JOIN: nested iteration
• CONSTRAINT: nested iteration
• UNION ALL