SQL 'like' vs '=' performance This question skirts around what I'm wondering, but the answers don't exactly address it. It would seem that in general '=' is faster than 'like' when using wildcards. This appears to be the conventional wisdom. However, lets suppose I have a column containing a limited number of different fixed, hardcoded, varchar identifiers, and I want to select all rows matching..