Home All Groups Group Topic Archive Search About

Linked server and query speed

Author
20 Nov 2007 4:40 PM
Mark Goldin
Why this query

declare @sku char(20)

set @sku = '02113'

select * from vamcpd...icitem

where citemno = @sku

is much slower then

select * from vamcpd...icitem

where citemno = '02113'



Thanks

AddThis Social Bookmark Button