Monthly Archives: April 2009

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 →