1
Speeding up SQL queries by orders of magnitude using UNION
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
Foxhound Systems is a custom software development company in Chicago that specializes in building fast, reliable, and intuitive software systems for companies across industries, with solutions serving millions of users globally.
Visit foxhound.systems → RSS feedOn Hacker News Jan 2021 – Mar 2021
Systems & Performance 1Software Engineering 1Programming Languages 1Databases & Data 1
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.