April 27, 2009 at 3:40 pm
psangeetha (4/27/2009)
Sorry, I have another doubt. Is it required to rebuild the views after the SP3 install??We are having some issues on a few programs that runs a view.
Thanks again.
No, you do not need to rebuild the views. Views are just saved queries that get expanded into the calling query and that result is then compiled and an execution plan built. If you are having problems, it could be due to outdated statistics - but my guess is that the query that is causing the problem needs to be tuned.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply