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 sandfly on Saturday March 20, 2021 @05:47PM (#26526306)
Do you lose the indices on the columns after the UNION?
[ Parent | on HN ]
Re:Speeding up SQL queries by orders of magnitude using UNION by ComputerGuru on Sunday March 21, 2021 @12:58AM (#26528226)
Definitely, but that is more than made up for by the much smaller size.
[ Parent | on HN ]