As far as I can see, your query

select top 100 * from dbo.StockLocationLog where mode='Dispatch'

- it's a "select all" query

- if there is any ndex on the "mode" column, it may not be selective enough.

Can you send the table definition, indexes included?