From 9168fc4ab4ba8fc0b011fdf10579726380c5bf02 Mon Sep 17 00:00:00 2001
From: David Kaufmann <astra@ionic.at>
Date: Sat, 6 Apr 2019 04:07:28 +0200
Subject: [PATCH] add first optimizations

---
 ex1/main_5.tex | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/ex1/main_5.tex b/ex1/main_5.tex
index a61253b..315cec5 100644
--- a/ex1/main_5.tex
+++ b/ex1/main_5.tex
@@ -1,6 +1,13 @@
 %ex1.5
 
 \begin{enumerate}[label=(\alph*)]
-	\item empty item oida!
+	\item SELECT distinct(displayname) FROM posts p JOIN users u ON u.id = p.owneruserid WHERE p.viewcount > u.views;
 
+local: 45s vs 31ms
+
+	\item SELECT score FROM comments WHERE text ILIKE 'yes\%'; <- did not work (100ms instead of 33ms)
+
+	\item SELECT postid FROM votes WHERE postid NOT IN (SELECT postid FROM votes WHERE votetypeid != 2);
+
+local: 16m vs 35ms
 \end{enumerate}
-- 
2.43.0