Umm, I don't "click through" my queries. Let's not try to dismiss a point by denigrating the person who makes it
I've been optimizing queries for well over a decade. One of the ways I've been doing it was through running them as stored procedures. That's something that took a while to find its way to MySQL.
As for Oracle, I used to like it a lot (especially pre-SQL 2005), if not their business practices. I actually started using it before MS SQL (especially since it was POS pre-2000, and 200 was only passable). However, MS SQL's comparative quality went seriously up with 2005, and Oracle's hasn't improved all that much. A lot of big companies still use it (and will continue using it, for many reasons, not all of which have to do with performance), but many that wouldn't even look towards MS SQL before are now adopting it.
I've been optimizing queries for well over a decade. One of the ways I've been doing it was through running them as stored procedures. That's something that took a while to find its way to MySQL.As for Oracle, I used to like it a lot (especially pre-SQL 2005), if not their business practices. I actually started using it before MS SQL (especially since it was POS pre-2000, and 200 was only passable). However, MS SQL's comparative quality went seriously up with 2005, and Oracle's hasn't improved all that much. A lot of big companies still use it (and will continue using it, for many reasons, not all of which have to do with performance), but many that wouldn't even look towards MS SQL before are now adopting it.


Comment