Flattened subqueries executed using unique reformatting

To perform unique reformatting, Adaptive Server:

And after the sort removes duplicates and creates the clustered index:

select title_id 
from titles, #publishers
where titles.pub_id = #publishers.pub_id

showplan messages for unique reformatting show “Worktable created for REFORMATTING” in Step 1, and “Using Clustered Index” on the worktable in Step 2.

dbcc traceon(310) displays “REFORMATTING with Unique Reformatting” for the method for the publishers table.