Queries are distributed in separate portions.
These query portions are never distributed:
- Read-write query portions (including DDL, INSERT, LOAD, UPDATE, and DELETE)
- Query portions that reference temporary tables
- Query portions that reference SYSTEM dbspace tables
- Query portions that reference proxy tables
- Query portions that reference nondeterministic functions, such as NEWID