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.

Check out our indexing resource page for more.

↑ Back to top
  1. Hi Team,

    I have see this session its really good. But in the demo scripts not appearing could you please post the scripts.


    • 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.

  2. thx a lot for sharing!

  3. Or you can watch on Apple TV or on Youtube from any console connected by hdmi like my psp3


    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.

    • Thanks Michael! They are great animals. If I can’t have a giraffe as a pet someday, the okapi is my second choice!

  5. 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

  6. Brent and Team,

    I am the follower of your products and technical advises.

    I am advised by my management team that we can separate the indexes from a Drive (in which database main file group is residing) to another Drive. Is this a good advise? Is it possible to separate Clustered indexes from the main file group? Will this give us a performance gain (like separating MDF, LDF and TempDB into each different drives)?

    Thanks in advance.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>