I've spoken with our network admin and we update the statistics every night with the full scan.

He also mentioned that several of our databases were highly fragmented, but the windows...

I have updated the statistics, but I don't know if I did FULL SCAN or not. Most likely I have not.

Query:

SELECT DISTINCT TOP 10

s.sale_key,

fc.freight_carrier_name,

isnull(os.freight_charges,0),

isnull(os.weight,0)

FROM...