Hi

In answer to your suggestions:

For the purposes of this post, I am running the identical query - the query is a stored procedure. I agree that a repeated query should...

Hi

Thanks for the replies

In answer to previous posts:

The NO LOCK hint makes no difference to the speed.

The queries take the same time to return - if 1 query is...

Hi

This is the query I am running (as a stored procedure)

SELECT T_Contract_Header.Code,

       T_Contract_Header.Description,

       T_Contract_Details.HotelID,

       T_Contract_Details.RecordNo,

       T_Contract_Details.ValidFrom,

       T_Contract_Details.ValidTo,

       T_Contract_Details.RoomType,

       T_Contract_Details.BoardBasis,

       T_Contract_Details.RateType,

       T_Contract_Details.AllocationType,

       T_Contract_Details.Quantity,

       T_Contract_Details.Information,

       T_Contract_Rates.MidweekAdultNett

FROM T_Contract_Header

LEFT JOIN T_Contract_Details ON T_Contract_Details.Code =...