ok..thanks

Query execution plan

http://www.mediafire.com/convkey/cbad/9pt99xg999borf1zg.jpg

Table schema is as follows:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TestTable](

[id] [bigint] IDENTITY(0,1) NOT NULL,

[sys_service_id] [bigint] NOT NULL,

[sys_msg_type] [int] NOT NULL,

[sys_proc_time] [datetime] NOT NULL,

[sys_proc_host] [varchar](45) NOT NULL,

[sys_asset_id] [varchar](45)...

clustered index is getting used as per the query plan.