This is the error I got when I have run the DBCC CHECKTABL query

Msg 8966, Level 16, State 2, Line 1

Unable to read and latch page (3:319) with latch type...

I am selecting column from TABLE1 depending on ColD (having noe clustered index).

Selecting columns from table on non-clustered index cause the performance problem.

Advanced thaks for all.I didn't expect this much...

ColD is integer datatype.

Thanks

Subha

Sorry. I am waiting for my PL approval.

Could you please confirm is searching based on the non-clustered index cause the performance problem.

Thanks

Subha

It's still running. Nearly 55 min.

Thanks

Subha

Sorry the table contain 700,000 records.

Thanks

Subha