News for hackers. Stuff that matters.

A comment on Speeding up SQL queries by orders of magnitude using UNION. Parent comment

Re:Speeding up SQL queries by orders of magnitude using UNION by Albert_Camus on Saturday March 20, 2021 @06:42PM (#26526611)
Author here, you are indeed correct that Query #2's final join can be an INNER join. However, I just tested it against our test data set and it makes no impact on the performance.
[ Parent | on HN ]
Re:Speeding up SQL queries by orders of magnitude using UNION by tech2 on Sunday March 21, 2021 @06:42AM (#26529481)
Ah well, thanks for humouring me. Good thing those query optimisers do the right thing on occasion.
[ Parent | on HN ]