Skip to content

Instantly share code, notes, and snippets.

@bifacil

bifacil/fullscan.sql

Created November 16, 2015 21:55
Show Gist options
  • Save bifacil/73e93860b7e99cde3e40 to your computer and use it in GitHub Desktop.
Save bifacil/73e93860b7e99cde3e40 to your computer and use it in GitHub Desktop.
Download ZIP
Sum 1 million rows
Raw
fullscan.sql
select sum(UNIDADES) AS Unidades FROM LB_VENTAS
SELECT count(*),sum( u1.n+u2.n+u3.n+u4.n+u5.n+u6.n) num
FROM
(SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u1,
(SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u2,
(SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u3,
(SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u4,
(SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u5,
(SELECT 0 n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) u6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment