Too bad CRICHARDSONS last reply was in September.

This sounds related to a problem I've having w/ SQL 2008. We upgraded last month (Db > 1TB).

A query that used to take about 2 minutes now takes 8. When I look at IO Stats, one thing that really stuck out was:

Table 'Worktable'. Scan count 7116008, logical reads 53304197, physical reads 0, read-ahead reads 0

The rest of my scancounts and logical reads are much much smaller.

Ala...

Table 'tbldEncntr'. Scan count 2, logical reads 29960, physical reads 53, read-ahead reads 14975

Table 'tbldAdj'. Scan count 1, logical reads 72430, physical reads 166, read-ahead reads 72407

Table 'tbllAdjCd'. Scan count 1, logical reads 8, physical reads 2, read-ahead reads 5

Table 'tbldChrg'. Scan count 4, logical reads 123750, physical reads 189, read-ahead reads 61863

Table 'tbllSite'. Scan count 2, logical reads 8, physical reads 0, read-ahead reads 0

Table 'tbllSiteGrp'. Scan count 3, logical reads 6, physical reads 0, read-ahead reads 0

Table 'tbldPaym'. Scan count 1, logical reads 78286, physical reads 197, read-ahead reads 78262

Table 'tblsSitePaycl_Perf'. Scan count 1, logical reads 138, physical reads 5, read-ahead reads 134