No, it will not run efficiently, because there is CAST() and LIKE %search% operations in conditions which will not able to use indexes
GabyYYZ (1/25/2010)
I have a colleague working on a side project to search all columns for any errant information that looks like a credit card and I was wondering if there are performance issues involved with this script? He's going about the concept of creating "dynamic" stored procedures as they run faster, but still trying to optimize it. Will this script work efficiently for truly massive amounts of data?