Hey Guyz,
I have come across a situation where I have to create an Indexed View to test the performance implications rather than going with a redesign which is a significant cost on the business.
How do I actually go about creating an Indexed View anyways?
Has anyone got any experience with it? Does the index need to be rebuilt every now and then to cater for the new records?
Cheers 🙂