3 ms·Yes, we use filtered indexes to mitigate it. It's a lot of additional boilerplate though.by MrZander 4y agoYes, we use filtered indexes to mitigate it. It's a lot of additional boilerplate though.