I am not sure how the code resolved any performance at all? Actually the use case itself was changed when the code was tweaked, so the results are different which is not the business use case at all. The first code had LIKE statement but never had % appended to it, which is not a normal practice at all in the database world. While the example shows to introduce % for address, but then replaces other fields with = which means that now the search IL that was bringing records where city field were like "Millwalkie" or "Philadelphia" will not come as a result in your search.
I am not sure how the code resolved any performance at all? Actually the use case itself was changed when the code was tweaked, so the results are different which is not the business use case at all. The first code had LIKE statement but never had % appended to it, which is not a normal practice at all in the database world. While the example shows to introduce % for address, but then replaces other fields with = which means that now the search IL that was bringing records where city field were like "Millwalkie" or "Philadelphia" will not come as a result in your search.
Loved this presantation. Please keep it going!