Thank you Helen! I really didn't know about this shortcoming. The failure to optimize makes sense given the issues with NULL. I'll definitely keep this in mind :)
The quirks of moving from database to database. I'm sure there will be more of these that cause queries to grind to a halt. :D
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.