2 ms·
Wow, 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-
by ilaksh 13y ago
Wow, 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.