I have created index using actual exection plan. Query save 25% time. Now data is completely getting on index basis.

CREATE NONCLUSTERED INDEX IndexName

ON dbo.Table1 (intId,bintTimeStamp)

INCLUDE (autTimeSeriesId,decValue,intTickStatus)

GO

I updated statistics by executing "sp_updatestats" store procedure but still the estimated no. of rows are around 3600 whereas actual rows are around 100,000 .. are coming.

thanks for giving reply...

Hi demonfox,

Actually i am new in sql, so could you please tell me What i have to do exactly?

Please find the attachment

Hello SQLRNNR & demonfox,

@demonfox

Table defination is:

CREATE TABLE TABLE1

(

autTimeSeriesId PRIMARY KEY IDENTITY(1,1),

...