From 8b7431f1edb34451c3448a9c1225bdb1b91e2417 Mon Sep 17 00:00:00 2001 From: David Kaufmann Date: Sun, 7 Apr 2019 22:53:36 +0200 Subject: [PATCH] add explanation to 1.5.a --- ex1/main_5.tex | 3 +++ 1 file changed, 3 insertions(+) diff --git a/ex1/main_5.tex b/ex1/main_5.tex index c800914..3a3531d 100644 --- a/ex1/main_5.tex +++ b/ex1/main_5.tex @@ -8,6 +8,9 @@ Optimized query: SELECT distinct(displayname) FROM posts p JOIN users u ON u.id = p.owneruserid WHERE p.viewcount > u.views; \end{verbatim} +Improvements:\\ +Just converted the selection to a JOIN + Original version: \begin{verbatim} Planning time: 0.978 ms -- 2.43.0