That’s a table scan, right there. Naughty.
Comment on It's that time of the year again!
Moops@lemmy.world 11 months agoAt the very least I’d try to clean up that fuzzy condition on behavior to anticipate any bad or inconsistent data entry.
WHER UPPER(TRIM(behavior)) = ‘NICE’
Depending on the possible values in behavior, adding a wildcard or two might be useful but would need to know more about that field to be certain. Personally I’d rather see if there was a methodology using code values or existing indicators instead of a string, but that’s often just wishful thinking.
moroni@lemmy.ca 11 months ago
mp04610@lemm.ee 11 months ago
behavior
is an ENUM.