Wow - now I am down to 1 sec. after I added the index:

CREATE NONCLUSTERED INDEX [IX_BRWEEKHIS_TEST]

ON [dbo].[BRFCLSeaWeekHis] ([PortFrom],[PortTo],[QuoteType],[Year])

INCLUDE ([CurrencyCode],[RateTotal],[SeaTotal],[Total])

However, the last two conversions I don't understand, because they seem...

Ok, now I think we are getting close. Down to 47 secs, but now it also suggests a new index:

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]

ON [dbo].[BRFCLSeaWeekHis] ([PortFrom],[PortTo],[QuoteType],[Year])

INCLUDE ([Week],[CarrierID],[ConType],[ConSize],[Commodity],[IncotermCode],[CurrencyCode],[RateTotal],[SeaTotal],[Total])

Thanks for the suggestion, but pretty much the same result

Are there any other tools I can use to dig deeper?

Table '#Result____00000005022E'. Scan count 0, logical reads 51, physical reads 0,...

Ah - here it is

I have this from the stats

Table '#Result_000000050139'. Scan count 0, logical reads 51, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads...

I have attached a file to the first post - is that what you need or if not, then please tell me how to get it 🙂

Hi Chris,

Thanks for the leads, but even with recompile and changed index, the time is the same.

In relation to your first post, then I will not likely get anymore than...