> *-- Partial match to index > SELECT holiday FROM table WHERE company = MyComp' AND fiscal = '2009' > *--- Returns back Index seek with corect index > > *-- Partial match to index with fields out of order > SELECT holiday FROM table WHERE fiscal = '2009' AND company = MyComp' > *--- Returns back Index seek with correct index > > *-- Skipping first field in index expression > SELECT holiday FROM table WHERE fiscal = '2009' AND holiday = 'Jan 1, 2009' > *--- Returns back Index scan with correct index > > *-- Return fields not in index and partial match on index > SELECT * FROM table WHERE company = 'MyComp' AND fiscal = '2009' > *-- Returns Index Scan and doesn't use the correct index uses primary key > > *-- Return fields not in index and full match on index > SELECT * FROM table WHERE company = 'MyComp' AND fscal = '2009' AND holiday = 'Jan 1, 2009' > *-- Even with exact match in where still Index Scan with primary key >Use first and last variations as they seem to be the best.