Can we use views to improve the performance for a query?
Indexed views will improve query performance if they are designed properly.
http://technet.microsoft.com/en-us/library/cc917715.aspx
EDIT : Be aware that unless you are using Enterprise Edition or Developer Edition, you'll need to specify the WITH (NOEXPAND) hint to get the performance boost in your selections.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With