SQL Server Performance

Views

Discussion in 'SQL Server 2008 General DBA Questions' started by rohaandba, May 2, 2011.

  1. rohaandba New Member

    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
  2. mmarovic Active Member

    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.

Share This Page