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