3 responses

  1. Glenn Berry
    October 18, 2011

    Nice post, Joe. Creating a purposely small filtered index on a large table and then dropping it is a good shortcut to get this without too much effort for the database server.

  2. Joe Sack
    October 18, 2011

    Thanks Glenn! Great tip too. Very low overhead solution depending on the predicate chosen.

  3. Ana Mihalj
    October 19, 2011

    It’s something new I learned today. Thank you for sharing this.

Back to top
mobile desktop