Planet MySQL

Displaying posts with tag: Set operations (SQL) (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 →

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links