This is a thing at SQL Server. If you are rocking the isDeleted column, why index the 75% of the rows that are deleted when you are never going to use the index to query against them? This sort of exclusion from a filter is doable.
No comments:
Post a Comment