Indexed Views
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/chedgate/indexedviews.asp
Edited by - chrhedga on 12/02/2003 01:34:30 AM
-
Great article Chris!
I just want to add that Enterprise edition (and Developer ed.) will also consider using the indexed view, even when the view is not used in the query at all. Using you example, after you've created the indexed view, the first JOIN between dbo.titles and dbo.publishers will also run faster, thanks to the index on the view.
Cheers!
.
-
Sorry, am I blind or does thread subject and article title not match?
I see 'What is denormalization' along with the articles about 'Indexed views'.
???
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
quote:
Sorry, am I blind or does thread subject and article title not match?I see 'What is denormalization' along with the articles about 'Indexed views'.
Hmm, well, Andy at SSC first named the article "What is denormalization" but I had him change it to "Indexed views". The thread is about the article Indexed views that is linked in the first post of the thread.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Co-author of Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles at sql.nu (http://www.sql.nu)
-
Seems to be a problem with the loader engine
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Changes once loaded dont update the forum title, I'll fix tonight.
Andy
-
quote:
Changes once loaded dont update the forum title, I'll fix tonight.No problem, I think most readers wont notice it.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Co-author of Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles at sql.nu (http://www.sql.nu)
-
Yes, I know, it might sound nit-picking
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Excellent article, however, I'm sure the value of indexed views can be communicated just as effectively without preaching to us about denormalization...which seems to be the author's real point of contention.
-
An excellent article that made me think about some of my tables while reading through it. I especially like the links to references at the bottom.
-
quote:
Excellent article, however, I'm sure the value of indexed views can be communicated just as effectively without preaching to us about denormalization...which seems to be the author's real point of contention.Of course, but that would probably make it just another copy-paste from Books Online, or at least a recap of probably a lot of other articles out there about indexed views.
--
Chris Hedgate @ Extralives (http://www.extralives.com/)
Co-author of Best of SQL Server Central 2002 (http://www.sqlservercentral.com/bestof/)
Articles at sql.nu (http://www.sql.nu)
-
See, I did change the title!
I see both sides on the denormalization thing. Ended up thinking that it was the right way to go for this article, not nearly enough people understand that any type of indexing is denormalizing.
As powerful as the feature is, the biggest reason I dont leverage it much is the schemabinding. I work in an environment where change DOES happen, schemabinding makes changes harder. Not that there is a better solution yet.
Andy
-
quote:
See, I did change the title!Yes, I see, but didn't post, because I don't want to sound picky again
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Quote: "Excellent article, however, I'm sure the value of indexed views can be communicated just as effectively without preaching to us about denormalization...which seems to be the author's real point of contention. "
Actually, the author is specifically using indexed views as an alternative to denormalizing the base tables. The use of indexed views as a way to bring about the same effect as denormalizing is an awesome technique if it works as described (which I'm testing right now).
Rock on, three points awarded to sanity's side.
cl
Signature is NULL
-
I am confused about what can and can't be done with SQL Server Standard Edition. I have Standard Edition and want to turn some of my existing views into indexed views if it will increase the performance of selects against them.
Is this possible?
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply