They are elusive and hard to spot in the wild, but they exist: rare index options that can enhance the performance of your queries. If you have a solid knowledge of index basics and want to add to your collection, this is the session for you! In this 30-minute video, Jes will show you how filtered indexes, compressed indexes, and indexed views work and can improve performance.
Want to get a closer view of the demos? Try full-screening the video – it’s available in 720p and 1080p.
siva January 30, 2013 | 1:28 pm
Hi Team,
I have see this session its really good. But in the demo scripts not appearing could you please post the scripts.
Tx
Siva
Brent Ozar January 30, 2013 | 7:37 pm
Hi, Siva. You can watch the session in high resolution to see the details. Click the gear icon when you’re watching the video to see a higher resolution, and you can go fullscreen as well.
thierry February 1, 2013 | 2:01 am
thx a lot for sharing!
Fernando Jacinto Alvarez February 1, 2013 | 10:52 am
Or you can watch on Apple TV or on Youtube from any console connected by hdmi like my psp3
Michael J Swart February 6, 2013 | 7:23 pm
http://michaeljswart.com/wp-content/uploads/2013/02/okapi.png
The first time I ever saw an Okapi was the weekend I attended my first SQL Saturday in Columbus Ohio. I think it was SQL Saturday 42. It’s also where I first talked to Jeremiah for the first time.
And it’s also where I talked to Brent for the first time … or would have been if he showed up (zing!)
Anyway, the family came with me that weekend and we stopped by the Columbus zoo on the way home where we all fell in love with the Okapi they had there. Ever since then we’ve been fascinated by the animal.
Thanks for a great webcast Jes! I came for the Okapi, but I stayed for the niche index features.
Jes Schultz Borland February 8, 2013 | 8:17 am
Thanks Michael! They are great animals. If I can’t have a giraffe as a pet someday, the okapi is my second choice!
Christoph Müller-Spengler April 19, 2013 | 9:32 am
Hello Jes,
i am watching this video right now on youtube. Thank you for sharing your knowledge.
One Question:
You created the Unique Clustered Index on both CustomerID and ProductID.
But when you queried the Indexed View by “WHERE PRODUCTID = 779″ we saw a SCAN.
I would have expected a SEEK. So why is it a SCAN?
Thank you in advance, Christoph