January 13, 2016 at 2:21 am
Hi All,
Can you please tell me the difference between Index view over Normal View. Where we can use Index view?
January 13, 2016 at 2:28 am
this link may help you
www.brentozar.com/archive/2013/11/what-you-can-and-cant-do-with-indexed-views/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 13, 2016 at 2:36 am
A normal view is like a macro definition in a third-generation language. It gets replaced by its definition before the query optimizer even sees it.
When you add an index to a view, then SQL Server will internally execute the SELECT in the view and store the results; it will also set up "hooks" in the underlying tables to ensure that the materialized view data is updated when the underlying data changes. This can speed up some queries, but at the expense of slowing down changes in the tables. Also, while virtually everything you can do in a query is allowed in a normal view, there are lots of restrictions on indexed views. See Books Online for the details.
January 13, 2016 at 2:58 am
Not able to open.
January 13, 2016 at 3:02 am
sorry
http://www.brentozar.com/archive/2013/11/what-you-can-and-cant-do-with-indexed-views/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 13, 2016 at 6:11 am
Always start with the Microsoft documentation when you have fundamental questions about what something is or how it works. For example, here's the information on indexed views. Then you can branch out to other areas to get more information. Here's a good article on Simple-Talk.[/url]
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply