From 63847496f14c813a5d80efd5b7de0f1294ffe1e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:11 +0200 Subject: Adding upstream version 3.45.1. Signed-off-by: Daniel Baumann --- www/images/qp/fqp1.gif | Bin 0 -> 19973 bytes www/images/qp/fqp1.pikchr | 36 +++++++++++++++++++++++++++ www/images/qp/fruitobstate.gif | Bin 0 -> 6949 bytes www/images/qp/fruitobstate0.gif | Bin 0 -> 12381 bytes www/images/qp/fullscan.gif | Bin 0 -> 7539 bytes www/images/qp/idx1.gif | Bin 0 -> 3954 bytes www/images/qp/idx1lu1.gif | Bin 0 -> 10702 bytes www/images/qp/idx1lu2.gif | Bin 0 -> 11201 bytes www/images/qp/idx1lu3.gif | Bin 0 -> 11175 bytes www/images/qp/idx2.gif | Bin 0 -> 3052 bytes www/images/qp/idx2lu1.gif | Bin 0 -> 10434 bytes www/images/qp/idx3.gif | Bin 0 -> 5205 bytes www/images/qp/idx3lu1.gif | Bin 0 -> 11927 bytes www/images/qp/idx3lu2.gif | Bin 0 -> 11013 bytes www/images/qp/idx4.gif | Bin 0 -> 6443 bytes www/images/qp/idx4lu1.gif | Bin 0 -> 7110 bytes www/images/qp/obfruitidx1.gif | Bin 0 -> 12100 bytes www/images/qp/obfruitidx4.gif | Bin 0 -> 7703 bytes www/images/qp/obfruitnoidx.gif | Bin 0 -> 8892 bytes www/images/qp/obrowid.gif | Bin 0 -> 7815 bytes www/images/qp/orquery.gif | Bin 0 -> 15623 bytes www/images/qp/partial-sort.gif | Bin 0 -> 15856 bytes www/images/qp/rowidlu.gif | Bin 0 -> 7182 bytes www/images/qp/tab.gif | Bin 0 -> 6392 bytes www/images/qp/tpchq8.gif | Bin 0 -> 33576 bytes www/images/qp/tpchq8.pikchr | 53 ++++++++++++++++++++++++++++++++++++++++ 26 files changed, 89 insertions(+) create mode 100644 www/images/qp/fqp1.gif create mode 100644 www/images/qp/fqp1.pikchr create mode 100644 www/images/qp/fruitobstate.gif create mode 100644 www/images/qp/fruitobstate0.gif create mode 100644 www/images/qp/fullscan.gif create mode 100644 www/images/qp/idx1.gif create mode 100644 www/images/qp/idx1lu1.gif create mode 100644 www/images/qp/idx1lu2.gif create mode 100644 www/images/qp/idx1lu3.gif create mode 100644 www/images/qp/idx2.gif create mode 100644 www/images/qp/idx2lu1.gif create mode 100644 www/images/qp/idx3.gif create mode 100644 www/images/qp/idx3lu1.gif create mode 100644 www/images/qp/idx3lu2.gif create mode 100644 www/images/qp/idx4.gif create mode 100644 www/images/qp/idx4lu1.gif create mode 100644 www/images/qp/obfruitidx1.gif create mode 100644 www/images/qp/obfruitidx4.gif create mode 100644 www/images/qp/obfruitnoidx.gif create mode 100644 www/images/qp/obrowid.gif create mode 100644 www/images/qp/orquery.gif create mode 100644 www/images/qp/partial-sort.gif create mode 100644 www/images/qp/rowidlu.gif create mode 100644 www/images/qp/tab.gif create mode 100644 www/images/qp/tpchq8.gif create mode 100644 www/images/qp/tpchq8.pikchr (limited to 'www/images/qp') diff --git a/www/images/qp/fqp1.gif b/www/images/qp/fqp1.gif new file mode 100644 index 0000000..bb95973 Binary files /dev/null and b/www/images/qp/fqp1.gif differ 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 Binary files /dev/null and b/www/images/qp/fruitobstate.gif differ diff --git a/www/images/qp/fruitobstate0.gif b/www/images/qp/fruitobstate0.gif new file mode 100644 index 0000000..d7368b9 Binary files /dev/null and b/www/images/qp/fruitobstate0.gif differ diff --git a/www/images/qp/fullscan.gif b/www/images/qp/fullscan.gif new file mode 100644 index 0000000..55e17cb Binary files /dev/null and b/www/images/qp/fullscan.gif differ diff --git a/www/images/qp/idx1.gif b/www/images/qp/idx1.gif new file mode 100644 index 0000000..4c13aae Binary files /dev/null and b/www/images/qp/idx1.gif differ diff --git a/www/images/qp/idx1lu1.gif b/www/images/qp/idx1lu1.gif new file mode 100644 index 0000000..e5b82f3 Binary files /dev/null and b/www/images/qp/idx1lu1.gif differ diff --git a/www/images/qp/idx1lu2.gif b/www/images/qp/idx1lu2.gif new file mode 100644 index 0000000..0206537 Binary files /dev/null and b/www/images/qp/idx1lu2.gif differ diff --git a/www/images/qp/idx1lu3.gif b/www/images/qp/idx1lu3.gif new file mode 100644 index 0000000..90fc71f Binary files /dev/null and b/www/images/qp/idx1lu3.gif differ diff --git a/www/images/qp/idx2.gif b/www/images/qp/idx2.gif new file mode 100644 index 0000000..9f59be3 Binary files /dev/null and b/www/images/qp/idx2.gif differ diff --git a/www/images/qp/idx2lu1.gif b/www/images/qp/idx2lu1.gif new file mode 100644 index 0000000..705dd2b Binary files /dev/null and b/www/images/qp/idx2lu1.gif differ diff --git a/www/images/qp/idx3.gif b/www/images/qp/idx3.gif new file mode 100644 index 0000000..4d8fdb6 Binary files /dev/null and b/www/images/qp/idx3.gif differ diff --git a/www/images/qp/idx3lu1.gif b/www/images/qp/idx3lu1.gif new file mode 100644 index 0000000..794b2bd Binary files /dev/null and b/www/images/qp/idx3lu1.gif differ diff --git a/www/images/qp/idx3lu2.gif b/www/images/qp/idx3lu2.gif new file mode 100644 index 0000000..b747d52 Binary files /dev/null and b/www/images/qp/idx3lu2.gif differ diff --git a/www/images/qp/idx4.gif b/www/images/qp/idx4.gif new file mode 100644 index 0000000..762ba17 Binary files /dev/null and b/www/images/qp/idx4.gif differ diff --git a/www/images/qp/idx4lu1.gif b/www/images/qp/idx4lu1.gif new file mode 100644 index 0000000..9444e1c Binary files /dev/null and b/www/images/qp/idx4lu1.gif differ diff --git a/www/images/qp/obfruitidx1.gif b/www/images/qp/obfruitidx1.gif new file mode 100644 index 0000000..3aa589b Binary files /dev/null and b/www/images/qp/obfruitidx1.gif differ diff --git a/www/images/qp/obfruitidx4.gif b/www/images/qp/obfruitidx4.gif new file mode 100644 index 0000000..a96e17f Binary files /dev/null and b/www/images/qp/obfruitidx4.gif differ diff --git a/www/images/qp/obfruitnoidx.gif b/www/images/qp/obfruitnoidx.gif new file mode 100644 index 0000000..253e1f4 Binary files /dev/null and b/www/images/qp/obfruitnoidx.gif differ diff --git a/www/images/qp/obrowid.gif b/www/images/qp/obrowid.gif new file mode 100644 index 0000000..47b0000 Binary files /dev/null and b/www/images/qp/obrowid.gif differ diff --git a/www/images/qp/orquery.gif b/www/images/qp/orquery.gif new file mode 100644 index 0000000..01566d5 Binary files /dev/null and b/www/images/qp/orquery.gif differ diff --git a/www/images/qp/partial-sort.gif b/www/images/qp/partial-sort.gif new file mode 100644 index 0000000..ae8053b Binary files /dev/null and b/www/images/qp/partial-sort.gif differ diff --git a/www/images/qp/rowidlu.gif b/www/images/qp/rowidlu.gif new file mode 100644 index 0000000..0e6e6bf Binary files /dev/null and b/www/images/qp/rowidlu.gif differ diff --git a/www/images/qp/tab.gif b/www/images/qp/tab.gif new file mode 100644 index 0000000..990c393 Binary files /dev/null and b/www/images/qp/tab.gif differ diff --git a/www/images/qp/tpchq8.gif b/www/images/qp/tpchq8.gif new file mode 100644 index 0000000..a290743 Binary files /dev/null and b/www/images/qp/tpchq8.gif differ 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 \ + 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 \ + 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 -- cgit v1.2.3