Hi, I have 4 views on my database on SQL Server 2008 R2, Its really taking more time to execute these views. How Can I Make the views to execute faster. I do have an idea of creating an Index on these Views, Can I go creating the index on the view or Can I do some thing else Please suggest me
I guess by "executing views" you mean "running queries involving that views".The question is too general. Creating views as indexed views might help, but it is not always necessary.To get a help you must be more specific. Post the code of your slow query and the definition of views involved.
