Index usage by %Like% operator – Query Tuning

Ok, so this one is interesting. I was reading an Internal DL (Distribution Group) post on tuning %Like% operator performance. I find some confusion in various places about index selectivity of ‘%Like%’ operator, and I decided to do few test myself. Hopefully test details below can help a bit: Problem Statement: – While optimizing high…

2