Planet MySQL

Displaying posts with tag: Oracle Database (reset)

Aug

2013

Posted by Lukas Eder on Wed 21 Aug 2013 16:15 UTC
Tags:

Oracle, sql, database, join, slow, Oracle Database, MySQL, Performance, hash join, Set operations (SQL)

In my recent SQL work for a large Swiss bank, I have maintained nested database view monsters whose unnested SQL code amounted up to 5k lines of code, joining the same table over and over again in separate subselects combined via UNION operations. This monster performed in way under 50ms, no matter how we queried … Continue reading The Myth About Slow SQL JOIN Operations →

Jan

2010

MySQL and PostgresSQL jobs on the Rise, Oracle job postings decline

Posted by Mark Hinkle on Fri 08 Jan 2010 19:09 UTC
Tags:

postgresql, Oracle, Uncategorized, database, Marten Mickos, Ingres, Add new tag, Oracle Database, MySQL

This tweet from former MySQL AB CEO Mårten Mickos caught my eye. It shows a trend of increased demand for MySQL and PostgresSQL expertise while job postings on job websites for those with Oracle and Ingres expertise declined.

I was a little shocked by the graph until you realize it’s just a trend. I then looked at the absolute number of jobs requesting database expertise and the story quickly becomes clear….

…

[Read more]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links