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] NOT NULL,

[QueueId] [tinyint] NOT NULL,

[CreatedDate] [datetime] NOT NULL,

[StartedDate] [datetime] NULL,

[CompletedDate] [datetime] NULL,

[CreatedEmpId] [smallint] NOT NULL,

[StartedEmpId] [smallint] NULL,

[CompletedEmpId] [smallint] NULL,

[IsActive] [bit] NULL,

CONSTRAINT [PK_trn_GJobDet1] PRIMARY KEY CLUSTERED

(

[GJobId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO