Am executat sintaxa

SET STATISTICS IO ON

select *
from statushistory
where sth_number in
(select pac_parcelNumber
from package)
AND sth_fk_sge is null
AND sth_fk_sat = 27

Acum a durat doar 8 secunde.

Rezultatul este acesta:

(0 row(s) affected)
Table 'StatusHistory'. Scan count 3, logical reads 38899, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Package'. Scan count 3, logical reads 24920, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.


Este posibil ca in perioada aceasta clientii sa nu foloseasca prea mult site-ul; nu gasesc alta explicatie.