Thomas,

I tried an index on ccustno - 30 seconds exactly, with or without.

CREATE PROCEDURE dbo.updateacme AS
update sostrs set nreserved = 0 where ccustno='ACME'
GO

33 seconds

Index in sostrs is clustered on cuid


>
>David;
>
>What happens if your index for SQL Server is on CCustno? How about using a stored procedure?
>
>Tom