26 files changed, 89 insertions, 0 deletions

diff --git a/www/images/qp/fqp1.gif b/www/images/qp/fqp1.gif
new file mode 100644
index 0000000..bb95973
--- /dev/null
+++ b/www/images/qp/fqp1.gif
diff --git a/www/images/qp/fqp1.pikchr b/www/images/qp/fqp1.pikchr
new file mode 100644
index 0000000..71ae5ba
--- /dev/null
+++ b/www/images/qp/fqp1.pikchr
@@ -0,0 +1,36 @@
+circle "P" big big bold fit rad 110%
+circlerad = P.rad
+movewid = P.diameter*0.8
+move
+circle "T" big big bold
+spline -> from 0.5mm above P.e \
+  then to 2mm above 0.5 between P and T \
+  then to 0.5mm above T.w
+text "4.8" small above at 2nd vertex of previous
+spline -> from 0.5mm below T.w \
+  then to 2mm below 0.5 between T and P \
+  then to 0.5mm below P.e
+text "4.4" small below at 2nd vertex of previous
+circle "*" bold rad 0.5*circlerad with .s at movewid above P.n
+arrow from previous.s to P.n " 4.9" small ljust
+circle "*" bold rad 0.5*circlerad with .s at movewid above T.n
+arrow from previous.s to T.n " 5.2" small ljust
+text "without ANALYZE" big bold at movewid*1.5 below 0.5 between P and T
+
+
+P: circle "P" big big bold at movewid*5.0 right of T
+move
+T: circle "T" big big bold
+spline -> from 0.5mm above P.e \
+  then to 2mm above 0.5 between P and T \
+  then to 0.5mm above T.w
+text "4.4" small above at 2nd vertex of previous
+spline -> from 0.5mm below T.w \
+  then to 2mm below 0.5 between T and P \
+  then to 0.5mm below P.e
+text "3.8" small below at 2nd vertex of previous
+circle "*" bold rad 0.5*circlerad with .s at movewid above P.n
+arrow from previous.s to P.n " 3.9" small ljust
+circle "*" bold rad 0.5*circlerad with .s at movewid above T.n
+arrow from previous.s to T.n " 6.1" small ljust
+text "with ANALYZE" big bold at movewid*1.5 below 0.5 between P and T
diff --git a/www/images/qp/fruitobstate.gif b/www/images/qp/fruitobstate.gif
new file mode 100644
index 0000000..c9f4337
--- /dev/null
+++ b/www/images/qp/fruitobstate.gif
diff --git a/www/images/qp/fruitobstate0.gif b/www/images/qp/fruitobstate0.gif
new file mode 100644
index 0000000..d7368b9
--- /dev/null
+++ b/www/images/qp/fruitobstate0.gif
diff --git a/www/images/qp/fullscan.gif b/www/images/qp/fullscan.gif
new file mode 100644
index 0000000..55e17cb
--- /dev/null
+++ b/www/images/qp/fullscan.gif
diff --git a/www/images/qp/idx1.gif b/www/images/qp/idx1.gif
new file mode 100644
index 0000000..4c13aae
--- /dev/null
+++ b/www/images/qp/idx1.gif
diff --git a/www/images/qp/idx1lu1.gif b/www/images/qp/idx1lu1.gif
new file mode 100644
index 0000000..e5b82f3
--- /dev/null
+++ b/www/images/qp/idx1lu1.gif
diff --git a/www/images/qp/idx1lu2.gif b/www/images/qp/idx1lu2.gif
new file mode 100644
index 0000000..0206537
--- /dev/null
+++ b/www/images/qp/idx1lu2.gif
diff --git a/www/images/qp/idx1lu3.gif b/www/images/qp/idx1lu3.gif
new file mode 100644
index 0000000..90fc71f
--- /dev/null
+++ b/www/images/qp/idx1lu3.gif
diff --git a/www/images/qp/idx2.gif b/www/images/qp/idx2.gif
new file mode 100644
index 0000000..9f59be3
--- /dev/null
+++ b/www/images/qp/idx2.gif
diff --git a/www/images/qp/idx2lu1.gif b/www/images/qp/idx2lu1.gif
new file mode 100644
index 0000000..705dd2b
--- /dev/null
+++ b/www/images/qp/idx2lu1.gif
diff --git a/www/images/qp/idx3.gif b/www/images/qp/idx3.gif
new file mode 100644
index 0000000..4d8fdb6
--- /dev/null
+++ b/www/images/qp/idx3.gif
diff --git a/www/images/qp/idx3lu1.gif b/www/images/qp/idx3lu1.gif
new file mode 100644
index 0000000..794b2bd
--- /dev/null
+++ b/www/images/qp/idx3lu1.gif
diff --git a/www/images/qp/idx3lu2.gif b/www/images/qp/idx3lu2.gif
new file mode 100644
index 0000000..b747d52
--- /dev/null
+++ b/www/images/qp/idx3lu2.gif
diff --git a/www/images/qp/idx4.gif b/www/images/qp/idx4.gif
new file mode 100644
index 0000000..762ba17
--- /dev/null
+++ b/www/images/qp/idx4.gif
diff --git a/www/images/qp/idx4lu1.gif b/www/images/qp/idx4lu1.gif
new file mode 100644
index 0000000..9444e1c
--- /dev/null
+++ b/www/images/qp/idx4lu1.gif
diff --git a/www/images/qp/obfruitidx1.gif b/www/images/qp/obfruitidx1.gif
new file mode 100644
index 0000000..3aa589b
--- /dev/null
+++ b/www/images/qp/obfruitidx1.gif
diff --git a/www/images/qp/obfruitidx4.gif b/www/images/qp/obfruitidx4.gif
new file mode 100644
index 0000000..a96e17f
--- /dev/null
+++ b/www/images/qp/obfruitidx4.gif
diff --git a/www/images/qp/obfruitnoidx.gif b/www/images/qp/obfruitnoidx.gif
new file mode 100644
index 0000000..253e1f4
--- /dev/null
+++ b/www/images/qp/obfruitnoidx.gif
diff --git a/www/images/qp/obrowid.gif b/www/images/qp/obrowid.gif
new file mode 100644
index 0000000..47b0000
--- /dev/null
+++ b/www/images/qp/obrowid.gif
diff --git a/www/images/qp/orquery.gif b/www/images/qp/orquery.gif
new file mode 100644
index 0000000..01566d5
--- /dev/null
+++ b/www/images/qp/orquery.gif
diff --git a/www/images/qp/partial-sort.gif b/www/images/qp/partial-sort.gif
new file mode 100644
index 0000000..ae8053b
--- /dev/null
+++ b/www/images/qp/partial-sort.gif
diff --git a/www/images/qp/rowidlu.gif b/www/images/qp/rowidlu.gif
new file mode 100644
index 0000000..0e6e6bf
--- /dev/null
+++ b/www/images/qp/rowidlu.gif
diff --git a/www/images/qp/tab.gif b/www/images/qp/tab.gif
new file mode 100644
index 0000000..990c393
--- /dev/null
+++ b/www/images/qp/tab.gif
diff --git a/www/images/qp/tpchq8.gif b/www/images/qp/tpchq8.gif
new file mode 100644
index 0000000..a290743
--- /dev/null
+++ b/www/images/qp/tpchq8.gif
diff --git a/www/images/qp/tpchq8.pikchr b/www/images/qp/tpchq8.pikchr
new file mode 100644
index 0000000..3ad9ebc
--- /dev/null
+++ b/www/images/qp/tpchq8.pikchr
@@ -0,0 +1,53 @@
+circle "S" big big bold fit rad 110%
+circlerad = S.rad
+movewid = S.diameter*0.8
+move
+circle "L" big big bold
+move
+circle "O" big big bold
+move
+circle "C" big big bold
+move
+circle "N1" big big bold
+move
+circle "R" big big bold
+circle "P" big big bold with .n at movewid below L.s
+circle "N2" big big bold with .e at movewid left of S.w
+
+define double_arrow {
+  spline -> from 0.5mm above $1.e \
+    then to 2mm above 0.5<$1,$2> \
+    then to 0.5mm above $2.w
+  text $3 small above at 2nd vertex of previous
+  spline <- from 0.5mm below $1.e \
+    then to 2mm below 0.5<$1,$2> \
+    then to 0.5mm below $2.w
+  text $4 small below at 2nd vertex of previous
+}
+double_arrow(N2,S,"6.00","2.08")
+double_arrow(S,L,"9.17","2.30")
+double_arrow(L,O,"2.77","4.03")
+double_arrow(O,C,"2.64","5.30")
+double_arrow(C,N1,"2.08","6.40")
+double_arrow(N1,R,"1.79","3.47")
+spline -> from 0.5mm right of L.s \
+   then to 2mm right of 0.5<L,P> \
+   then to 0.5mm right of P.n
+text "2.64" small ljust at 2nd vertex of previous
+spline <- from 0.5mm left of L.s \
+   then to 2mm left of 0.5<L,P> \
+   then to 0.5mm left of P.n
+text "6.01" small rjust at 2nd vertex of previous
+define any_down {
+  circle "*" bold rad 0.5*circlerad with .s at movewid above $1.n
+  arrow from previous.s to $1.n $2 small ljust
+}
+any_down(N2," 5.52")
+any_down(S, " 9.47")
+any_down(L, " 16.40")
+any_down(O, " 13.87")
+any_down(C, " 12.56")
+any_down(N1," 5.52")
+any_down(R, " 3.56")
+circle "*" bold rad 0.5*circlerad with .n at movewid below P.s
+arrow from previous.n to P.s " 7.71" small ljust