Adding index in table suggestion?
I'd create a seperate index on SKU and ModelNumber. I don't think an index on RetailerID will do much good as there won't be many different retailers . 

The best approach to analyze this is by comparing the execution plans &amp; times of the different sets of indexes