we have one default clustered index PK_trn_GJobDet1 alone and the table definition is below

CREATE TABLE [dbo].[Trn_GJobDet](

[GJobId] [int] IDENTITY(1,1) NOT NULL,

[JobCardId] [int] NOT NULL,

[StageId] [smallint] NOT NULL,

[SubJobId] [int] NOT NULL,

[ProcessId] [smallint]...

Thanks for the quick replay

Update Trn_GJobDet set CompletedDate=getdate() , CompletedEmpId=4335

Where QueueId < 2 and JobCardId=116111 and StageId=53 and

SubJobId=971218 and CompletedDate is Null and IsActive=1 ...