Hi,

Please find the attached execute plan in .sqlplan format.

Please help me in this regard.

Note : Just now i got the file. Sorry for delayed response.

Thanks,

Syed.

Please find the attached Execution Plan in excel.

Thanks,

Syed

Yes I too agree, client cannot view that much record at a slot.

But the requirement which i got is like that.

Thanks,

Syed.

Please find index definitions.

Thanks,

Syed.

Two different indexes.

Thanks,

Syed

Development also giving the same issue.

Thanks,

Syed.

Hi,

Please find the attached file having Table definition, Index definition, and execution plan (FROM Development server)

Query used,

select col_name1, max(col_name2),max(col_name3),max(date_time)

from tble_candt

where date_time between '2011-01-01' and '2012-06-30'

group by col_name1

order by date_time desc;

The...

Hi Thanks for your replay,

Please see the attached snapshot will xplain you about the nonclustered index reference.

Thanks,

Syed

Thanks for your reply.

Please find the attached screen shots for indexes used.

there is no keys for this tble_candt table.

Table script :

CREATE TABLE tble_candt(

[col_name1] [varchar](10) NULL,

[col_name2] [nvarchar](25) NULL,

[col_name3] [nvarchar](64) NULL,

[col_name4]...

Thanks for the reply,

Could you please ellaborate on this, I am not getting exactly.

Syed.