What is a federated index

A union is an index of multiple fields

Why do I care about the order in a federated index

In plain English, fields will be compared only if the first field is the same

In general, columns with frequent query requirements or high field selectivity are placed first