That query optimiser is in many ways amazing, but it's mostly undocumented and the behaviour changes from version to version of the database.
Re:Oracle’s Cloud Licensing Change
by user5994461 on Sunday January 29, 2017 @10:12AM
(#13514419)
- Oracle was the only SQL DB able to shard. (might still be)
- Oracle was the only database able to take multi GB or TB of data in a single table/DB. (Old MySQL/Postgre had various limitations like X GB per table for a long time, they still do).
If you worked in the DB in the 200X years, Oracle was the standard and for good reasons. MySQL/Postgre were considered like toys, for good reasons.
Re:Oracle’s Cloud Licensing Change
by Dangeranger on Sunday January 29, 2017 @04:39PM
(#13516864)
We are not making the comparison 10 years ago, we are making it now. What real features does Oracle have that MySQL/Maria/PostgreSQL do not have now.
Re:Oracle’s Cloud Licensing Change
by user5994461 on Sunday January 29, 2017 @05:20PM
(#13517119)
Short version: Nothing changed in 10 years :D
So far the features that oracle had that people have mentioned:
- An amazing query optimizer
- Replication (enabling High Availability) features available 15 years ago