Thank you all for all your suggestions!!!

I think I've learnt quite a bit on indexing just working on this query:-) and sure Gail, will remember to post it on...

Hi,

I had to go with the composite clustered index(cSpecialty, id) columns becuase, the cSpecialty column is not unique by itself, so had to join that with the auto increment field.

Rgds.

Hi,

I'm using SQL 2000 and I didn't know how to save it as .sqlpan, so attaching screenshots of the exec plan. I will check how to do this.

It takes about...

Hello!

I have been looking on the net to solve an issue and found this entry, which is so much like mine. Hope someone can help. I have a table that...