原文:Will a filtering on a field benefit from a composite key that contains that field, among others?
If I have a composite key (primary or plain index) based on fields, say Year(int) and Ord(int), will filtering WHERE Year=2011 benefit from that key or will it ignore it completely?