Tuesday, August 14, 2012

Which column order to have a better clustering factor ?

  • Clearly some columns will have a better CF than other columns
  • Therefore, with a concatenated index, it makes sense that the index column order will impact clustering factor of index
  • The CF of columns worthy of consideration when determining index column ordering if all columns are likely to be referenced

No comments:

Post a Comment