Some queries generate additional blocks or messages in dbcc traceon(302) output, as follows:
Queries that contain an order by clause contain additional blocks for displaying the analysis of indexes that can be used to avoid performing a sort.
See “Sort avert messages” for more information.
Queries using transaction isolation level 0 (dirty reads) or updatable cursors on allpages-locked tables, where unique indexes are required, return a message like the following:
Considering unique index ’au_id_ix’, indid 2.
Queries that specify an invalid prefetch size return a message like the following:
Forced data prefetch size of 8K is not available. The largest available prefetch size will be used.