Changeset: daa4cfd0419b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/daa4cfd0419b
Modified Files:
sql/scripts/76_dump.sql
Branch: default
Log Message:
Use UNION ALL as it is faster (no deduplication done).
diffs (12 lines):
diff --git a/sql/scripts/76_dump.sql b/sql/scripts/76_dump.sql
--- a/sql/scripts/76_dump.sql
+++ b/sql/scripts/76_dump.sql
@@ -328,7 +328,7 @@ BEGIN
INSERT INTO sys.dump_statements SELECT (SELECT COUNT(*) FROM
sys.dump_statements) + RANK() OVER(ORDER BY stmts.o), stmts.s
FROM (
SELECT f.o, f.stmt FROM
sys.dump_functions f
- UNION
+ UNION ALL
SELECT t.o, t.stmt FROM sys.dump_tables t
) AS stmts(o, s);
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
