Thanks for all your help with this everyone. It turns out that the 2 servers are running different service packs (even though they shouldn't be) so I haven't been...

Ok. Thanks for your help anyway. What I don't understand is why SQL Server should decide to use different execution plans for such a simple query against 2...

Here is the statement:

SELECT cheque_amount FROM attributes

WHERE cheque_amount = '100.00'

AND object_class = 'cheque'

And here are the 2 execution plans:

Server 1 - slow query

Execution Tree

--------------

Parallelism(Gather Streams)

|--Clustered Index Scan(OBJECT:([DBNAME].[dbo].[ATTRIBUTES].[ATTRIBUTE_ID]), WHERE:([ATTRIBUTES].[CHEQUE_AMOUNT]='100.00'...

Hi Frank.

Apologies for this but I'm on a very steep learning curve at the moment and this is my first entry on this site.

The question is why doesn't this query...