|
Comments
|
|
awesome info.
|
|
|
Another good point to add to this would be if the "covering index" will still be used efficiently when only using the indexed column and not the included columns.
|
|
|
What impact on the physical structure of the index does the "include" impose (i.e. size, performance, etc.).
|
|
|
Good example. Thank you.
|
|
|
good
|
|
|
Maybe add a brief mention on why NOT to use the included columns. I might think that ALL columans should always be indcluded.
|
|
titokapotito on
12/18/2008
Great Tip, thanks for the video....
Looking forward to see more videos in this page
|
|
|
Should note that INCLUDE columns are not supported in UNIQUE constraint definitions but only in CREATE INDEX statements.
|
|
|
Excellent
|
|
|
Excellent
|
|
|
Nice and concise explanation. Should help lots of people. Thanks Grant.
|
|
|
new trchnique - well introduced
|
|
|
good
|
|
|
More explanation on the INCLUDE statement would have been helpful.
|
|
|
Consequences of adding too many include columns in indexes?
|
|
|
nice video , it would be better to add explanation about seek predicates and outputlist in the exec plan of clustered index
|
|
|
INCLUDE is a new one for this developer. Great stuff. I would have liked to be able to see the full query text... flashed by and then the where clause dropped off the screen.
|
|
|
Clear and concise.....
|
|
|
Excellent reminder. More like this please!
|
|
|
I liked this...but it would have been nice to have the video explain the difference between an index that uses the "include" phrase for columns and an index that just indexes those additional columns themselves (advantages/disadvantages/differences)
|
|
|
As usual, excellent video!
|
|
david thomas on
5/24/2011
Good Tip
|
|
|
good one
|
|
idris chambas on
5/24/2011
Excellent tip. Thanks, Grant.
|
|
|
Excellent !
|
|
|
Excellent!
|
|
|
Nice video, but what's the difference between creating a covered index and using INCLUDE? It seems that in both cases the "extra" columns have to somehow become part of the index structure.
|
|
|
Clear and concise. Thanks!
|
|
|
Awsome!
|
|
|
You might have made a second index that is covering (leaving the first) and showing the relative performance. Or, you might have shown the cost of the first query versus the cost of the second.
|
|
|
Fantastic
|
|
|
Grant, you are great
|
|
Maurice Ivory on
10/31/2011
It was cool, I enjoyed this learning about this.
|