4 ms·
MySQL's query optimizer is a joke compared to Oracle's. If you don't do joins and just use it as a key-value store, that doesn't matter. MySQL also doesn't en
by cmccabe 13y ago
MySQL's query optimizer is a joke compared to Oracle's. If you don't do joins and just use it as a key-value store, that doesn't matter. MySQL also doesn't enforce most SQL constraints like "can't store a string in an int field" etc.
- ilaksh 13y agoWow, that's interesting if the SQL constraints are all completely ignored.. seems doubtful. My experience with Oracle's query optimization was that it was non-intuitive to configure to work correctly especially with the way that the optimizer statistics config works. MySQL will do quite useful query optimization (for joins) if you have appropriate indexes. So I think that in 80% of cases that is what matters in both Oracle and MySQL -- creating appropriate indexes. Honestly I don't think you know what MySQL is capable of.