Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query Optimizer gets it right, but occasionally there are queries that would benefit from tuning.

Get smart with SQL Backup Pro Get faster, smaller backups with integrated verification. Quickly and easily DBCC CHECKDB your backups. Learn more.