is it possible to create two indexes with the same keys by changing the collation parameters each time?
According to my best friend named documentation,
You can create multiple indexes on the same key(s) with different collations. To create indexes with the same key pattern but different collations, you must supply unique index names.
1 Like