Category Archives: Uncategorized

Statistics are only maintained on the first column of a composite index. Because of this, SQL Server’s Query Optimizer might not make as good use of composite indexes as it could. If you suspect that a composite index is not … Continue reading →

An index that has a distinct value is a selective index. Therefore, a unique index has a really high selective quotient as there are no replica entries. That is, it has potential for being called more often. Invariably, this follows … Continue reading →

Statistics are the next performance booster that we can look into after getting our indexes right and optimized. Statistics contain the information, distribution and have the task of deciding the selectivity of the indexes that we have defined. This is … Continue reading →