Friday, 7 March 2014

What is a Sparse Index?


What is a Sparse Index?


Answer:

Sparse Join Indexes are a type of Join Index which contains a WHERE clause that reduces the number of rows which would otherwise be included in the index. All types of join indexes, including single table, multitable, simple or aggregate can be sparse.

No comments:

Post a Comment