A practical use for filtered indexes

3 thoughts on “A practical use for filtered indexes”

  1. I doubt that constraints will get filters, partially because of the foreign keys. Somehow I can’t see a foreign key that only applies to certain rows in a table. Kinda violates the idea of referential integrity.

    Hmmm, now I can’t blog on this without looking like a copycat. Oh well, there are other fun things to be done with filtered indexes… 😉

  2. Sorry Gail but I beat you to it. 😉 But you’re the master so I know you will post on a more advanced use of filtered indexes.

Comments are closed.