Subject Index performance question
Author fabiano_bonin
Let's supose i have a table with a pk and two more fields, field1
and field2, where field1 has almost always the same value for all
records and field2 has more variations.

Is there some performance difference if i create an index using
(field2, field1) against (field1, field2), supposing i will make a
query using these two fields in the criteria?

Thanks.