Hi,

my issue got fixed with the help of excution plan. i was missing required non-clustered index on top of my table.

Thanks

Execution plan

...

Table Creation

/****** Object: Table [dbo].[tblGLJnlEntrySum] Script Date: 02/12/2013 04:55:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblGLJnlEntrySum](

[BatchID] [bigint] NOT NULL,

[RecID] [bigint] NOT NULL,

[GLBatchID] [bigint] NOT...