SQL: Filtered indexes in SQL Server can be wonderful but be careful !

added by DotNetKicks
1/14/2019 1:28:34 PM

1 Kicks, 457 Views

Back to the transaction table Two weeks ago, I wrote about the issues with a large transaction table where only a handful of the rows were unfinalized, and that we would never use an index to find all the rows that were finalized. But we'd certainly want an index defined for the ones that weren't.