October 6, 2015 at 10:29 am
Just tell me YES or NO and that's it !
Thank You and you may close this issue.
October 6, 2015 at 10:32 am
Yes.
Though it's pretty useless to just say yes/no, as there are lots of caveats, limitations and considerations.
https://msdn.microsoft.com/en-za/library/ms191432.aspx
https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2015 at 10:55 am
Can you add an index to a view?
Yes. Indexed views are useful for materializing aggregate queries and / or joins. But it can negatively impact table insert and update performance.
This article provides a good overview.
https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply