I have a million reasons why I personally will use and recommend Oracle.
The only reason why I have ever used MySQL is because someone paid me and I had no choice in the tech platform pick.
Just a few reasons Pro Oracle -
The most advance partitioning and sub partitioning implementation by far. Way more options for customizing business solutions. Makes PaaS work a breeze.
The most advance optimizer that can handle every sophisticated way to model data (except graph data.) This includes trivial things like nested sub queries which MySQL still hasn't figured out last time I checked to more advance things like recursive queries which should not even be attempted in MySQL.
It has the most advanced analytic functions built in that leverage powerful operations at the C
…show more content…
PL/SQL, packages, functions, procedures etc. Oracle empowers clean coding and the re-usability of code that interacts with data objects. MySQL empowers writing code outside the database which is farther away from the data.
BitMap indexes are very powerful for data warehouse domains with particular kinds of cardinality and has no MySQL equal.
Oracle allows you to customize your data base and your hardware to your solution with a large amount of variability and design choices that empower super tuning options. MySQL has almost no level of configuration by comparison.
Oracle has infinitely more instrumentation which is essential if you want to know what is going on under the hood and have a need to fine tune your hardware, your data base and your app. i.e. There is no TkProf equal in MySQL
Fine Grain Access or row level security is trivial and elegant to implement in Oracle and is a mess by equivalent requiring way more code than is necessary to do in MySQL. Oracle security in general is just more powerful in every way.
Oracle data compression is way more sophisticated and reduces IT