waxingsatirical (11/14/2012)
Hi Gaz,The code I've posted is just some sample code to replicate the problem. When this happened in real life the persisted column was not just a repeat of another column in the table!
Good, I'd hope not! 🙂
Would need a closer approximation of your specific scenario to try and reproduce - if I make the change I mentioned above then the covering index is used in query 3 & 4. So I can't really tell what's happening in your case with the information given.
Thanks
Gaz