I’ve been curious of how the optimizer behaves when using parameterized SQL with a LIKE clause.  Wildcard values that have a wildcard character in front generally do not seek on indexes.  I was curious how the optimizer deals with this from a cached plan perspective – would placement of the wildcard character cause recompilations?  I […]