[development-axapta] Index field priority

[thnathan]

When creating an index in Axapta, does the order in which fields appear 
in the index, affect which fields take preference when querying the 
table?
or does SQL determine which field would be better to search with?