Subject | Index performance question |
---|---|
Author | fabiano_bonin |
Post date | 2003-05-12T13:51Z |
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.
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.