SQL SERVER Interview Questions & Answers - SET 1 (50 ...

If the column has density value 1, it means all the records have same v alue in that column and less selectivity. Higher the density lowers the selectivity. If the column has density value 0.003, that means there are 1/0.003=333 distinct values in that column. Density = 1 / (Number of distinct values for a column or set of c olumn) ................
................

In order to avoid copyright disputes, this page is only a partial summary.