Hahahaha Dave Ballantyne!! hello

I know you! used to be a SQL Server DBA at a place where you worked, I remember a debacle about permissions we once had...

That was about...

It wasn't, it was still doing a clustered index scan on the primary key. I used a query hint after that and it did do a index seek but the...

I added the index and it hardly made any difference at all, would making the view an indexed view be worth looking at?

Thanks for the replies

DcPeterson,

Yes thats the kind of thing I want to do, I wasn't sure whether to make the index across all the columns or use included columns....

Thanks very much 🙂

Thanks for your response, the reason I was a bit scepticle was for exactly the same reason you have mentioned it was suggesting a massive covered index over 10 columns,...