An index can support only one collation per index column. If multiple collations are of interest, multiple indexes may be needed. Consider these
A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate
Page 2 of 2