2 SET pg_hint_plan.enable_hint TO on;
3 SET pg_hint_plan.debug_print TO on;
4 SET client_min_messages TO LOG;
5 SET search_path TO public;
8 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
10 \! sql/maskout.sh results/ut-R.tmpout
13 ---- No. R-1-1 specified pattern of the object name
17 \o results/ut-R.tmpout
19 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
21 \! sql/maskout.sh results/ut-R.tmpout
24 \o results/ut-R.tmpout
26 EXPLAIN SELECT * FROM s1.t1 t_1, s1.t2 t_2 WHERE t_1.c1 = t_2.c1;
28 \! sql/maskout.sh results/ut-R.tmpout
31 \o results/ut-R.tmpout
33 EXPLAIN SELECT * FROM s1.t1 t_1, s1.t2 t_2 WHERE t_1.c1 = t_2.c1;
35 \! sql/maskout.sh results/ut-R.tmpout
38 ---- No. R-1-2 specified schema name in the hint option
42 \o results/ut-R.tmpout
44 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
46 \! sql/maskout.sh results/ut-R.tmpout
49 \o results/ut-R.tmpout
50 /*+Rows(s1.t1 s1.t2 #1)*/
51 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
53 \! sql/maskout.sh results/ut-R.tmpout
56 ---- No. R-1-3 table doesn't exist in the hint option
60 \o results/ut-R.tmpout
62 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
64 \! sql/maskout.sh results/ut-R.tmpout
67 \o results/ut-R.tmpout
69 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
71 \! sql/maskout.sh results/ut-R.tmpout
74 ---- No. R-1-4 conflict table name
78 \o results/ut-R.tmpout
80 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
82 \! sql/maskout.sh results/ut-R.tmpout
86 \o results/ut-R.tmpout
87 EXPLAIN SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = s2.t1.c1;
89 \! sql/maskout.sh results/ut-R.tmpout
91 \o results/ut-R.tmpout
93 EXPLAIN SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = s2.t1.c1;
95 \! sql/maskout.sh results/ut-R.tmpout
97 \o results/ut-R.tmpout
98 /*+Rows(s1.t1 s2.t1 #1)*/
99 EXPLAIN SELECT * FROM s1.t1, s2.t1 WHERE s1.t1.c1 = s2.t1.c1;
101 \! sql/maskout.sh results/ut-R.tmpout
103 \o results/ut-R.tmpout
104 EXPLAIN SELECT * FROM s1.t1, s2.t1 s2t1 WHERE s1.t1.c1 = s2t1.c1;
106 \! sql/maskout.sh results/ut-R.tmpout
108 \o results/ut-R.tmpout
109 /*+Rows(t1 s2t1 #1)*/
110 EXPLAIN SELECT * FROM s1.t1, s2.t1 s2t1 WHERE s1.t1.c1 = s2t1.c1;
112 \! sql/maskout.sh results/ut-R.tmpout
115 \o results/ut-R.tmpout
116 EXPLAIN SELECT *, (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
118 \! sql/maskout.sh results/ut-R.tmpout
120 \o results/ut-R.tmpout
122 EXPLAIN SELECT *, (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
124 \! sql/maskout.sh results/ut-R.tmpout
126 \o results/ut-R.tmpout
127 /*+Rows(st1 st2 #1)Rows(t1 t2 #1)*/
128 EXPLAIN SELECT *, (SELECT max(st1.c1) FROM s1.t1 st1, s1.t2 st2 WHERE st1.c1 = st2.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
130 \! sql/maskout.sh results/ut-R.tmpout
133 ---- No. R-1-5 conflict table name
137 \o results/ut-R.tmpout
139 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
141 \! sql/maskout.sh results/ut-R.tmpout
144 \o results/ut-R.tmpout
146 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
148 \! sql/maskout.sh results/ut-R.tmpout
151 \o results/ut-R.tmpout
153 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
155 \! sql/maskout.sh results/ut-R.tmpout
157 \o results/ut-R.tmpout
158 EXPLAIN SELECT * FROM s1.t1, s1.t2, s1.t3 WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
160 \! sql/maskout.sh results/ut-R.tmpout
162 \o results/ut-R.tmpout
164 EXPLAIN SELECT * FROM s1.t1, s1.t2, s1.t3, s1.t4 WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1 AND t1.c1 = t4.c1;
166 \! sql/maskout.sh results/ut-R.tmpout
169 ---- No. R-1-6 object type for the hint
173 \o results/ut-R.tmpout
175 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
177 \! sql/maskout.sh results/ut-R.tmpout
180 \o results/ut-R.tmpout
181 EXPLAIN SELECT * FROM s1.p1 t1, s1.p1 t2 WHERE t1.c1 = t2.c1;
183 \! sql/maskout.sh results/ut-R.tmpout
185 \o results/ut-R.tmpout
187 EXPLAIN SELECT * FROM s1.p1 t1, s1.p1 t2 WHERE t1.c1 = t2.c1;
189 \! sql/maskout.sh results/ut-R.tmpout
192 \o results/ut-R.tmpout
193 EXPLAIN SELECT * FROM s1.ul1 t1, s1.ul1 t2 WHERE t1.c1 = t2.c1;
195 \! sql/maskout.sh results/ut-R.tmpout
197 \o results/ut-R.tmpout
199 EXPLAIN SELECT * FROM s1.ul1 t1, s1.ul1 t2 WHERE t1.c1 = t2.c1;
201 \! sql/maskout.sh results/ut-R.tmpout
204 CREATE TEMP TABLE tm1 (LIKE s1.t1 INCLUDING ALL);
205 \o results/ut-R.tmpout
206 EXPLAIN SELECT * FROM tm1 t1, tm1 t2 WHERE t1.c1 = t2.c1;
208 \! sql/maskout.sh results/ut-R.tmpout
210 \o results/ut-R.tmpout
212 EXPLAIN SELECT * FROM tm1 t1, tm1 t2 WHERE t1.c1 = t2.c1;
214 \! sql/maskout.sh results/ut-R.tmpout
217 CREATE TEMP TABLE t_pg_class WITH OIDS AS SELECT * from pg_class LIMIT 100;
218 \o results/ut-R.tmpout
219 EXPLAIN SELECT * FROM t_pg_class t1, t_pg_class t2 WHERE t1.oid = t2.oid;
221 \! sql/maskout.sh results/ut-R.tmpout
223 \o results/ut-R.tmpout
225 EXPLAIN SELECT * FROM t_pg_class t1, t_pg_class t2 WHERE t1.oid = t2.oid;
227 \! sql/maskout.sh results/ut-R.tmpout
234 \o results/ut-R.tmpout
235 EXPLAIN SELECT * FROM s1.f1() t1, s1.f1() t2 WHERE t1.c1 = t2.c1;
237 \! sql/maskout.sh results/ut-R.tmpout
239 \o results/ut-R.tmpout
241 EXPLAIN SELECT * FROM s1.f1() t1, s1.f1() t2 WHERE t1.c1 = t2.c1;
243 \! sql/maskout.sh results/ut-R.tmpout
246 \o results/ut-R.tmpout
247 EXPLAIN SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS t1 (c1, c2, c3, c4), s1.t2 WHERE t1.c1 = t2.c1;
249 \! sql/maskout.sh results/ut-R.tmpout
251 \o results/ut-R.tmpout
253 EXPLAIN SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS t1 (c1, c2, c3, c4), s1.t2 WHERE t1.c1 = t2.c1;
255 \! sql/maskout.sh results/ut-R.tmpout
257 \o results/ut-R.tmpout
258 /*+Rows(*VALUES* t2 #1)*/
259 EXPLAIN SELECT * FROM (VALUES(1,1,1,'1'), (2,2,2,'2'), (3,3,3,'3')) AS t1 (c1, c2, c3, c4), s1.t2 WHERE t1.c1 = t2.c1;
261 \! sql/maskout.sh results/ut-R.tmpout
264 \o results/ut-R.tmpout
265 EXPLAIN WITH c1(c1) AS (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) SELECT * FROM s1.t1, c1 WHERE t1.c1 = c1.c1;
267 \! sql/maskout.sh results/ut-R.tmpout
269 \o results/ut-R.tmpout
270 /*+Rows(t1 t2 #1)Rows(t1 c1 +1)*/
271 EXPLAIN WITH c1(c1) AS (SELECT max(t1.c1) FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1) SELECT * FROM s1.t1, c1 WHERE t1.c1 = c1.c1;
273 \! sql/maskout.sh results/ut-R.tmpout
276 \o results/ut-R.tmpout
277 EXPLAIN SELECT * FROM s1.v1 t1, s1.v1 t2 WHERE t1.c1 = t2.c1;
279 \! sql/maskout.sh results/ut-R.tmpout
281 \o results/ut-R.tmpout
283 EXPLAIN SELECT * FROM s1.v1 t1, s1.v1 t2 WHERE t1.c1 = t2.c1;
285 \! sql/maskout.sh results/ut-R.tmpout
287 \o results/ut-R.tmpout
288 /*+Rows(v1t1 v1t1_ #1)*/
289 EXPLAIN SELECT * FROM s1.v1 t1, s1.v1_ t2 WHERE t1.c1 = t2.c1;
291 \! sql/maskout.sh results/ut-R.tmpout
294 \o results/ut-R.tmpout
295 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.c1 = (SELECT max(st1.c1) FROM s1.t1 st1, s1.t2 st2 WHERE st1.c1 = st2.c1);
297 \! sql/maskout.sh results/ut-R.tmpout
299 \o results/ut-R.tmpout
300 /*+Rows(t1 t2 #1)Rows(st1 st2 #1)*/
301 EXPLAIN (COSTS true) SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1 AND t1.c1 = (SELECT max(st1.c1) FROM s1.t1 st1, s1.t2 st2 WHERE st1.c1 = st2.c1);
303 \! sql/maskout.sh results/ut-R.tmpout
305 -- There are cases where difference in the measured value and predicted value
306 -- depending upon the version of PostgreSQL
309 \o results/ut-R.tmpout
310 EXPLAIN SELECT * FROM s1.t1, (SELECT t2.c1 FROM s1.t2) st2 WHERE t1.c1 = st2.c1;
312 \! sql/maskout.sh results/ut-R.tmpout
314 \o results/ut-R.tmpout
316 EXPLAIN SELECT * FROM s1.t1, (SELECT t2.c1 FROM s1.t2) st2 WHERE t1.c1 = st2.c1;
318 \! sql/maskout.sh results/ut-R.tmpout
320 \o results/ut-R.tmpout
322 EXPLAIN SELECT * FROM s1.t1, (SELECT t2.c1 FROM s1.t2) st2 WHERE t1.c1 = st2.c1;
324 \! sql/maskout.sh results/ut-R.tmpout
328 ---- No. R-1-7 specified number of conditions
332 \o results/ut-R.tmpout
334 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
336 \! sql/maskout.sh results/ut-R.tmpout
339 \o results/ut-R.tmpout
341 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
343 \! sql/maskout.sh results/ut-R.tmpout
346 \o results/ut-R.tmpout
347 /*+Rows(t1 t2 #notrows)*/
348 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
350 \! sql/maskout.sh results/ut-R.tmpout
353 ---- No. R-2-1 some complexity query blocks
357 \o results/ut-R.tmpout
359 Leading(bmt1 bmt2 bmt3 bmt4)
360 Leading(b1t2 b1t3 b1t4 b1t1)
361 Leading(b2t3 b2t4 b2t1 b2t2)
362 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
363 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
364 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
367 SELECT max(bmt1.c1), (
368 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
370 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
372 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
375 \! sql/maskout.sh results/ut-R.tmpout
377 \o results/ut-R.tmpout
379 Leading(bmt1 bmt2 bmt3 bmt4)
380 Leading(b1t2 b1t3 b1t4 b1t1)
381 Leading(b2t3 b2t4 b2t1 b2t2)
382 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
383 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
384 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
385 Rows(bmt1 bmt2 #1)Rows(bmt1 bmt2 bmt3 #1)Rows(bmt1 bmt2 bmt3 bmt4 #1)
386 Rows(b1t2 b1t3 #1)Rows(b1t2 b1t3 b1t4 #1)Rows(b1t2 b1t3 b1t4 b1t1 #1)
387 Rows(b2t3 b2t4 #1)Rows(b2t3 b2t4 b2t1 #1)Rows(b2t3 b2t4 b2t1 b2t2 #1)
390 SELECT max(bmt1.c1), (
391 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
393 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1)
394 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
397 \! sql/maskout.sh results/ut-R.tmpout
400 \o results/ut-R.tmpout
402 Leading(bmt1 bmt2 bmt3 bmt4)
403 Leading(b1t2 b1t3 b1t4 b1t1)
404 Leading(b2t3 b2t4 b2t1 b2t2)
405 Leading(b3t4 b3t1 b3t2 b3t3)
406 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
407 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
408 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
409 MergeJoin(b3t4 b3t1)HashJoin(b3t4 b3t1 b3t2)NestLoop(b3t1 b3t2 b3t3 b3t4)
412 SELECT max(bmt1.c1), (
413 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
415 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
417 SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
419 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
422 \! sql/maskout.sh results/ut-R.tmpout
424 \o results/ut-R.tmpout
426 Leading(bmt1 bmt2 bmt3 bmt4)
427 Leading(b1t2 b1t3 b1t4 b1t1)
428 Leading(b2t3 b2t4 b2t1 b2t2)
429 Leading(b3t4 b3t1 b3t2 b3t3)
430 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
431 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
432 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
433 MergeJoin(b3t4 b3t1)HashJoin(b3t4 b3t1 b3t2)NestLoop(b3t1 b3t2 b3t3 b3t4)
434 Rows(bmt1 bmt2 #1)Rows(bmt1 bmt2 bmt3 #1)Rows(bmt1 bmt2 bmt3 bmt4 #1)
435 Rows(b1t2 b1t3 #1)Rows(b1t2 b1t3 b1t4 #1)Rows(b1t2 b1t3 b1t4 b1t1 #1)
436 Rows(b2t3 b2t4 #1)Rows(b2t3 b2t4 b2t1 #1)Rows(b2t3 b2t4 b2t1 b2t2 #1)
437 Rows(b3t4 b3t1 #1)Rows(b3t4 b3t1 b3t2 #1)Rows(b3t1 b3t2 b3t3 b3t4 #1)
440 SELECT max(bmt1.c1), (
441 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
443 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
445 SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
447 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
450 \! sql/maskout.sh results/ut-R.tmpout
453 \o results/ut-R.tmpout
455 Leading(bmt4 bmt3 bmt2 bmt1)
457 EXPLAIN SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
459 \! sql/maskout.sh results/ut-R.tmpout
461 \o results/ut-R.tmpout
463 Leading(bmt4 bmt3 bmt2 bmt1)
464 Rows(bmt4 bmt3 #1)Rows(bmt4 bmt3 bmt2 #1)Rows(bmt1 bmt2 bmt3 bmt4 #1)
466 EXPLAIN SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
468 \! sql/maskout.sh results/ut-R.tmpout
471 \o results/ut-R.tmpout
473 Leading(bmt4 bmt3 bmt2 bmt1)
475 EXPLAIN SELECT max(bmt1.c1) FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
477 \! sql/maskout.sh results/ut-R.tmpout
479 \o results/ut-R.tmpout
481 Leading(bmt4 bmt3 bmt2 bmt1)
482 Rows(bmt4 bmt3 #1)Rows(bmt4 bmt3 bmt2 #1)Rows(bmt1 bmt2 bmt3 bmt4 #1)
484 EXPLAIN SELECT max(bmt1.c1) FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
486 \! sql/maskout.sh results/ut-R.tmpout
489 \o results/ut-R.tmpout
491 Leading(bmt1 bmt2 bmt3 bmt4)
492 Leading(b1t2 b1t3 b1t4 b1t1)
493 Leading(b2t3 b2t4 b2t1 b2t2)
494 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
495 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
496 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
499 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
501 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
503 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
506 \! sql/maskout.sh results/ut-R.tmpout
508 \o results/ut-R.tmpout
510 Leading(bmt1 bmt2 bmt3 bmt4)
511 Leading(b1t2 b1t3 b1t4 b1t1)
512 Leading(b2t3 b2t4 b2t1 b2t2)
513 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
514 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
515 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
516 Rows(bmt1 bmt2 #1)Rows(bmt1 bmt2 bmt3 #1)Rows(bmt1 bmt2 bmt3 bmt4 #1)
517 Rows(b1t2 b1t3 #1)Rows(b1t2 b1t3 b1t4 #1)Rows(b1t2 b1t3 b1t4 b1t1 #1)
518 Rows(b2t3 b2t4 #1)Rows(b2t3 b2t4 b2t1 #1)Rows(b2t3 b2t4 b2t1 b2t2 #1)
521 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
523 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
525 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
529 \! sql/maskout.sh results/ut-R.tmpout
532 \o results/ut-R.tmpout
534 Leading(bmt1 bmt2 bmt3 bmt4)
535 Leading(b1t2 b1t3 b1t4 b1t1)
536 Leading(b2t3 b2t4 b2t1 b2t2)
537 Leading(b3t4 b3t1 b3t2 b3t3)
538 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
539 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
540 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
541 MergeJoin(b3t4 b3t1)HashJoin(b3t4 b3t1 b3t2)NestLoop(b3t1 b3t2 b3t3 b3t4)
544 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
546 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
548 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
550 SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
554 \! sql/maskout.sh results/ut-R.tmpout
556 \o results/ut-R.tmpout
558 Leading(bmt1 bmt2 bmt3 bmt4)
559 Leading(b1t2 b1t3 b1t4 b1t1)
560 Leading(b2t3 b2t4 b2t1 b2t2)
561 Leading(b3t4 b3t1 b3t2 b3t3)
562 MergeJoin(bmt1 bmt2)HashJoin(bmt1 bmt2 bmt3)NestLoop(bmt1 bmt2 bmt3 bmt4)
563 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
564 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
565 MergeJoin(b3t4 b3t1)HashJoin(b3t4 b3t1 b3t2)NestLoop(b3t1 b3t2 b3t3 b3t4)
566 Rows(bmt1 bmt2 #1)Rows(bmt1 bmt2 bmt3 #1)Rows(bmt1 bmt2 bmt3 bmt4 #1)
567 Rows(b1t2 b1t3 #1)Rows(b1t2 b1t3 b1t4 #1)Rows(b1t2 b1t3 b1t4 b1t1 #1)
568 Rows(b2t3 b2t4 #1)Rows(b2t3 b2t4 b2t1 #1)Rows(b2t3 b2t4 b2t1 b2t2 #1)
569 Rows(b3t4 b3t1 #1)Rows(b3t4 b3t1 b3t2 #1)Rows(b3t1 b3t2 b3t3 b3t4 #1)
572 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
574 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
576 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
578 SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
582 \! sql/maskout.sh results/ut-R.tmpout
585 \o results/ut-R.tmpout
587 Leading(c2 c1 bmt1 bmt2 bmt3 bmt4)
588 Leading(b1t2 b1t3 b1t4 b1t1)
589 Leading(b2t3 b2t4 b2t1 b2t2)
590 MergeJoin(c2 c1)HashJoin(c2 c1 bmt1)NestLoop(c2 c1 bmt1 bmt2)MergeJoin(c2 c1 bmt1 bmt2 bmt3)HashJoin(c2 c1 bmt1 bmt2 bmt3 bmt4)
591 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
592 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
596 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
599 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
601 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
603 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
608 \! sql/maskout.sh results/ut-R.tmpout
610 \o results/ut-R.tmpout
612 Leading(c2 c1 bmt1 bmt2 bmt3 bmt4)
613 Leading(b1t2 b1t3 b1t4 b1t1)
614 Leading(b2t3 b2t4 b2t1 b2t2)
615 MergeJoin(c2 c1)HashJoin(c2 c1 bmt1)NestLoop(c2 c1 bmt1 bmt2)MergeJoin(c2 c1 bmt1 bmt2 bmt3)HashJoin(c2 c1 bmt1 bmt2 bmt3 bmt4)
616 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
617 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
618 Rows(c2 c1 #1)Rows(c2 c1 bmt1 #1)Rows(c2 c1 bmt1 bmt2 #1)Rows(c2 c1 bmt1 bmt2 bmt3 #1)Rows(c2 c1 bmt1 bmt2 bmt3 bmt4 #1)
619 Rows(b1t2 b1t3 #1)Rows(b1t2 b1t3 b1t4 #1)Rows(b1t2 b1t3 b1t4 b1t1 #1)
620 Rows(b2t3 b2t4 #1)Rows(b2t3 b2t4 b2t1 #1)Rows(b2t3 b2t4 b2t1 b2t2 #1)
624 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
627 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
629 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
631 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
635 \! sql/maskout.sh results/ut-R.tmpout
638 \o results/ut-R.tmpout
640 Leading(c3 c2 c1 bmt1 bmt2 bmt3 bmt4)
641 Leading(b1t2 b1t3 b1t4 b1t1)
642 Leading(b2t3 b2t4 b2t1 b2t2)
643 Leading(b3t4 b3t1 b3t2 b3t3)
644 MergeJoin(c3 c2)HashJoin(c3 c2 c1)NestLoop(c3 c2 c1 bmt1)MergeJoin(c3 c2 c1 bmt1 bmt2)HashJoin(c3 c2 c1 bmt1 bmt2 bmt3)NestLoop(c3 c2 c1 bmt1 bmt2 bmt3 bmt4)
645 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
646 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
647 MergeJoin(b3t4 b3t1)HashJoin(b3t4 b3t1 b3t2)NestLoop(b3t1 b3t2 b3t3 b3t4)
651 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
654 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
657 SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
659 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
661 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
666 \! sql/maskout.sh results/ut-R.tmpout
668 \o results/ut-R.tmpout
670 Leading(c3 c2 c1 bmt1 bmt2 bmt3 bmt4)
671 Leading(b1t2 b1t3 b1t4 b1t1)
672 Leading(b2t3 b2t4 b2t1 b2t2)
673 Leading(b3t4 b3t1 b3t2 b3t3)
674 MergeJoin(c3 c2)HashJoin(c3 c2 c1)NestLoop(c3 c2 c1 bmt1)MergeJoin(c3 c2 c1 bmt1 bmt2)HashJoin(c3 c2 c1 bmt1 bmt2 bmt3)NestLoop(c3 c2 c1 bmt1 bmt2 bmt3 bmt4)
675 MergeJoin(b1t2 b1t3)HashJoin(b1t2 b1t3 b1t4)NestLoop(b1t2 b1t3 b1t4 b1t1)
676 MergeJoin(b2t3 b2t4)HashJoin(b2t3 b2t4 b2t1)NestLoop(b2t3 b2t4 b2t1 b2t2)
677 MergeJoin(b3t4 b3t1)HashJoin(b3t4 b3t1 b3t2)NestLoop(b3t1 b3t2 b3t3 b3t4)
678 Rows(c3 c2 #1)Rows(c3 c2 c1 #1)Rows(c3 c2 c1 bmt1 #1)Rows(c3 c2 c1 bmt1 bmt2 #1)Rows(c3 c2 c1 bmt1 bmt2 bmt3 #1)Rows(c3 c2 c1 bmt1 bmt2 bmt3 bmt4 #1)
679 Rows(b1t2 b1t3 #1)Rows(b1t2 b1t3 b1t4 #1)Rows(b1t2 b1t3 b1t4 b1t1 #1)
680 Rows(b2t3 b2t4 #1)Rows(b2t3 b2t4 b2t1 #1)Rows(b2t3 b2t4 b2t1 b2t2 #1)
681 Rows(b3t4 b3t1 #1)Rows(b3t4 b3t1 b3t2 #1)Rows(b3t1 b3t2 b3t3 b3t4 #1)
685 SELECT max(b1t1.c1) FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
688 SELECT max(b2t1.c1) FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
691 SELECT max(b3t1.c1) FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
693 SELECT max(bmt1.c1) FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4
695 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1
700 \! sql/maskout.sh results/ut-R.tmpout
703 ---- No. R-2-2 the number of the tables per quiry block
707 \o results/ut-R.tmpout
713 SELECT b1t1.c1 FROM s1.t1 b1t1 WHERE b1t1.c1 = 1
716 SELECT b2t1.c1 FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
718 FROM s1.t1 bmt1, c1 WHERE bmt1.c1 = 1
721 SELECT b3t1.c1 FROM s1.t1 b3t1 WHERE b3t1.c1 = 1
724 \! sql/maskout.sh results/ut-R.tmpout
726 \o results/ut-R.tmpout
736 SELECT b1t1.c1 FROM s1.t1 b1t1 WHERE b1t1.c1 = 1
739 SELECT b2t1.c1 FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
741 FROM s1.t1 bmt1, c1 WHERE bmt1.c1 = 1
744 SELECT b3t1.c1 FROM s1.t1 b3t1 WHERE b3t1.c1 = 1
747 \! sql/maskout.sh results/ut-R.tmpout
750 \o results/ut-R.tmpout
752 Leading(c1 bmt2 bmt1)
757 HashJoin(c1 bmt1 bmt2)
764 SELECT b1t1.c1 FROM s1.t1 b1t1, s1.t2 b1t2 WHERE b1t1.c1 = b1t2.c1
767 SELECT b2t1.c1 FROM s1.t1 b2t1, s1.t2 b2t2 WHERE b2t1.c1 = b2t2.c1
769 FROM s1.t1 bmt1, s1.t2 bmt2, c1 WHERE bmt1.c1 = bmt2.c1
772 SELECT b3t1.c1 FROM s1.t1 b3t1, s1.t2 b3t2 WHERE b3t1.c1 = b3t2.c1
775 \! sql/maskout.sh results/ut-R.tmpout
777 \o results/ut-R.tmpout
779 Leading(c1 bmt2 bmt1)
784 HashJoin(c1 bmt1 bmt2)
789 Rows(c1 bmt1 bmt2 #1)
796 SELECT b1t1.c1 FROM s1.t1 b1t1, s1.t2 b1t2 WHERE b1t1.c1 = b1t2.c1
799 SELECT b2t1.c1 FROM s1.t1 b2t1, s1.t2 b2t2 WHERE b2t1.c1 = b2t2.c1
801 FROM s1.t1 bmt1, s1.t2 bmt2, c1 WHERE bmt1.c1 = bmt2.c1
804 SELECT b3t1.c1 FROM s1.t1 b3t1, s1.t2 b3t2 WHERE b3t1.c1 = b3t2.c1
808 \! sql/maskout.sh results/ut-R.tmpout
811 \o results/ut-R.tmpout
813 Leading(c1 bmt4 bmt3 bmt2 bmt1)
814 Leading(b1t4 b1t3 b1t2 b1t1)
815 Leading(b2t4 b2t3 b2t2 b2t1)
816 Leading(b3t4 b3t3 b3t2 b3t1)
818 HashJoin(c1 bmt4 bmt3)
819 NestLoop(c1 bmt4 bmt3 bmt2)
820 MergeJoin(c1 bmt4 bmt3 bmt2 bmt1)
822 NestLoop(b1t4 b1t3 b1t2)
823 MergeJoin(b1t4 b1t3 b1t2 b1t1)
825 NestLoop(b2t4 b2t3 b2t2)
826 MergeJoin(b2t4 b2t3 b2t2 b2t1)
828 NestLoop(b3t4 b3t3 b3t2)
829 MergeJoin(b3t4 b3t3 b3t2 b3t1)
833 SELECT b1t1.c1 FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
836 SELECT b2t1.c1 FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
838 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1 AND bmt1.c1 = c1.c1
840 SELECT b3t1.c1 FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
843 \! sql/maskout.sh results/ut-R.tmpout
845 \o results/ut-R.tmpout
847 Leading(c1 bmt4 bmt3 bmt2 bmt1)
848 Leading(b1t4 b1t3 b1t2 b1t1)
849 Leading(b2t4 b2t3 b2t2 b2t1)
850 Leading(b3t4 b3t3 b3t2 b3t1)
852 HashJoin(c1 bmt4 bmt3)
853 NestLoop(c1 bmt4 bmt3 bmt2)
854 MergeJoin(c1 bmt4 bmt3 bmt2 bmt1)
856 NestLoop(b1t4 b1t3 b1t2)
857 MergeJoin(b1t4 b1t3 b1t2 b1t1)
859 NestLoop(b2t4 b2t3 b2t2)
860 MergeJoin(b2t4 b2t3 b2t2 b2t1)
862 NestLoop(b3t4 b3t3 b3t2)
863 MergeJoin(b3t4 b3t3 b3t2 b3t1)
865 Rows(c1 bmt4 bmt3 #1)
866 Rows(c1 bmt4 bmt3 bmt2 #1)
867 Rows(c1 bmt4 bmt3 bmt2 bmt1 #1)
869 Rows(b1t4 b1t3 b1t2 #1)
870 Rows(b1t4 b1t3 b1t2 b1t1 #1)
872 Rows(b2t4 b2t3 b2t2 #1)
873 Rows(b2t4 b2t3 b2t2 b2t1 #1)
875 Rows(b3t4 b3t3 b3t2 #1)
876 Rows(b3t4 b3t3 b3t2 b3t1 #1)
880 SELECT b1t1.c1 FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
883 SELECT b2t1.c1 FROM s1.t1 b2t1, s1.t2 b2t2, s1.t3 b2t3, s1.t4 b2t4 WHERE b2t1.c1 = b2t2.c1 AND b2t1.c1 = b2t3.c1 AND b2t1.c1 = b2t4.c1
885 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1 AND bmt1.c1 = c1.c1
887 SELECT b3t1.c1 FROM s1.t1 b3t1, s1.t2 b3t2, s1.t3 b3t3, s1.t4 b3t4 WHERE b3t1.c1 = b3t2.c1 AND b3t1.c1 = b3t3.c1 AND b3t1.c1 = b3t4.c1
890 \! sql/maskout.sh results/ut-R.tmpout
893 \o results/ut-R.tmpout
895 Leading(c1 bmt4 bmt3 bmt2 bmt1)
896 Leading(b1t4 b1t3 b1t2 b1t1)
898 HashJoin(c1 bmt4 bmt3)
899 NestLoop(c1 bmt4 bmt3 bmt2)
900 MergeJoin(c1 bmt4 bmt3 bmt2 bmt1)
902 HashJoin(b1t4 b1t3 b1t2)
903 NestLoop(b1t4 b1t3 b1t2 b1t1)
907 SELECT b1t1.c1 FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
910 SELECT b2t1.c1 FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
912 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1 AND bmt1.c1 = c1.c1
914 SELECT b3t1.c1 FROM s1.t1 b3t1
917 \! sql/maskout.sh results/ut-R.tmpout
919 \o results/ut-R.tmpout
921 Leading(c1 bmt4 bmt3 bmt2 bmt1)
922 Leading(b1t4 b1t3 b1t2 b1t1)
924 HashJoin(c1 bmt4 bmt3)
925 NestLoop(c1 bmt4 bmt3 bmt2)
926 MergeJoin(c1 bmt4 bmt3 bmt2 bmt1)
928 HashJoin(b1t4 b1t3 b1t2)
929 NestLoop(b1t4 b1t3 b1t2 b1t1)
931 Rows(c1 bmt4 bmt3 #1)
932 Rows(c1 bmt4 bmt3 bmt2 #1)
933 Rows(c1 bmt4 bmt3 bmt2 bmt1 #1)
935 Rows(b1t4 b1t3 b1t2 #1)
936 Rows(b1t4 b1t3 b1t2 b1t1 #1)
940 SELECT b1t1.c1 FROM s1.t1 b1t1, s1.t2 b1t2, s1.t3 b1t3, s1.t4 b1t4 WHERE b1t1.c1 = b1t2.c1 AND b1t1.c1 = b1t3.c1 AND b1t1.c1 = b1t4.c1
943 SELECT b2t1.c1 FROM s1.t1 b2t1 WHERE b2t1.c1 = 1
945 FROM s1.t1 bmt1, s1.t2 bmt2, s1.t3 bmt3, s1.t4 bmt4, c1 WHERE bmt1.c1 = bmt2.c1 AND bmt1.c1 = bmt3.c1 AND bmt1.c1 = bmt4.c1 AND bmt1.c1 = c1.c1
947 SELECT b3t1.c1 FROM s1.t1 b3t1
950 \! sql/maskout.sh results/ut-R.tmpout
953 ---- No. R-2-3 RULE or VIEW
957 \o results/ut-R.tmpout
959 Leading(r1 t1 t2 t3 t4)
961 EXPLAIN UPDATE s1.r1 SET c1 = c1 WHERE c1 = 1;
963 \! sql/maskout.sh results/ut-R.tmpout
965 \o results/ut-R.tmpout
967 Leading(r1 t1 t2 t3 t4)
968 Rows(r1 t1 t2 t3 t4 #2)
973 EXPLAIN UPDATE s1.r1 SET c1 = c1 WHERE c1 = 1;
975 \! sql/maskout.sh results/ut-R.tmpout
977 \o results/ut-R.tmpout
979 Leading(r1_ b1t1 b1t2 b1t3 b1t4)
981 EXPLAIN UPDATE s1.r1_ SET c1 = c1 WHERE c1 = 1;
983 \! sql/maskout.sh results/ut-R.tmpout
985 \o results/ut-R.tmpout
987 Leading(r1_ b1t1 b1t2 b1t3 b1t4)
988 Rows(r1_ b1t1 b1t2 b1t3 b1t4 #2)
989 Rows(r1_ b1t1 b1t2 b1t3 #2)
990 Rows(r1_ b1t1 b1t2 #2)
993 EXPLAIN UPDATE s1.r1_ SET c1 = c1 WHERE c1 = 1;
995 \! sql/maskout.sh results/ut-R.tmpout
998 \o results/ut-R.tmpout
1000 Leading(r2 t1 t2 t3 t4)
1002 EXPLAIN UPDATE s1.r2 SET c1 = c1 WHERE c1 = 1;
1004 \! sql/maskout.sh results/ut-R.tmpout
1006 \o results/ut-R.tmpout
1008 Leading(r2 t1 t2 t3 t4)
1009 Rows(r2 t1 t2 t3 t4 #2)
1010 Rows(r2 t1 t2 t3 #2)
1014 EXPLAIN UPDATE s1.r2 SET c1 = c1 WHERE c1 = 1;
1016 \! sql/maskout.sh results/ut-R.tmpout
1018 \o results/ut-R.tmpout
1020 Leading(r2_ b1t1 b1t2 b1t3 b1t4)
1021 Leading(r2_ b2t1 b2t2 b2t3 b2t4)
1023 EXPLAIN UPDATE s1.r2_ SET c1 = c1 WHERE c1 = 1;
1025 \! sql/maskout.sh results/ut-R.tmpout
1027 \o results/ut-R.tmpout
1029 Leading(r2_ b1t1 b1t2 b1t3 b1t4)
1030 Leading(r2_ b2t1 b2t2 b2t3 b2t4)
1032 Rows(r2_ b1t1 b1t2 #2)
1033 Rows(r2_ b1t1 b1t2 b1t3 #2)
1034 Rows(r2_ b1t1 b1t2 b1t3 b1t4 #2)
1036 Rows(r2_ b2t1 b2t2 #2)
1037 Rows(r2_ b2t1 b2t2 b2t3 #2)
1038 Rows(r2_ b2t1 b2t2 b2t3 b2t4 #2)
1040 EXPLAIN UPDATE s1.r2_ SET c1 = c1 WHERE c1 = 1;
1042 \! sql/maskout.sh results/ut-R.tmpout
1045 \o results/ut-R.tmpout
1047 Leading(r3 t1 t2 t3 t4)
1049 EXPLAIN UPDATE s1.r3 SET c1 = c1 WHERE c1 = 1;
1051 \! sql/maskout.sh results/ut-R.tmpout
1053 \o results/ut-R.tmpout
1055 Leading(r3 t1 t2 t3 t4)
1056 Rows(r3 t1 t2 t3 t4 #2)
1057 Rows(r3 t1 t2 t3 #2)
1061 EXPLAIN UPDATE s1.r3 SET c1 = c1 WHERE c1 = 1;
1063 \! sql/maskout.sh results/ut-R.tmpout
1065 \o results/ut-R.tmpout
1067 Leading(r3_ b1t1 b1t2 b1t3 b1t4)
1068 Leading(r3_ b2t1 b2t2 b2t3 b2t4)
1069 Leading(r3_ b3t1 b3t2 b3t3 b3t4)
1071 EXPLAIN UPDATE s1.r3_ SET c1 = c1 WHERE c1 = 1;
1073 \! sql/maskout.sh results/ut-R.tmpout
1075 \o results/ut-R.tmpout
1077 Leading(r3_ b1t1 b1t2 b1t3 b1t4)
1078 Leading(r3_ b2t1 b2t2 b2t3 b2t4)
1079 Leading(r3_ b3t1 b3t2 b3t3 b3t4)
1081 Rows(r3_ b1t1 b1t2 #2)
1082 Rows(r3_ b1t1 b1t2 b1t3 #2)
1083 Rows(r3_ b1t1 b1t2 b1t3 b1t4 #2)
1085 Rows(r3_ b2t1 b2t2 #2)
1086 Rows(r3_ b2t1 b2t2 b2t3 #2)
1087 Rows(r3_ b2t1 b2t2 b2t3 b2t4 #2)
1089 Rows(r3_ b3t1 b3t2 #2)
1090 Rows(r3_ b3t1 b3t2 b3t3 #2)
1091 Rows(r3_ b3t1 b3t2 b3t3 b3t4 #2)
1093 EXPLAIN UPDATE s1.r3_ SET c1 = c1 WHERE c1 = 1;
1095 \! sql/maskout.sh results/ut-R.tmpout
1098 \o results/ut-R.tmpout
1099 /*+HashJoin(v1t1 v1t1)*/
1100 EXPLAIN SELECT * FROM s1.v1 v1, s1.v1 v2 WHERE v1.c1 = v2.c1;
1102 \! sql/maskout.sh results/ut-R.tmpout
1104 \o results/ut-R.tmpout
1105 /*+HashJoin(v1t1 v1t1)Rows(v1t1 v1t1 #1)*/
1106 EXPLAIN SELECT * FROM s1.v1 v1, s1.v1 v2 WHERE v1.c1 = v2.c1;
1108 \! sql/maskout.sh results/ut-R.tmpout
1111 \o results/ut-R.tmpout
1112 /*+NestLoop(v1t1 v1t1_)*/
1113 EXPLAIN SELECT * FROM s1.v1 v1, s1.v1_ v2 WHERE v1.c1 = v2.c1;
1115 \! sql/maskout.sh results/ut-R.tmpout
1117 \o results/ut-R.tmpout
1118 /*+NestLoop(v1t1 v1t1_)Rows(v1t1 v1t1_ #1)*/
1119 EXPLAIN SELECT * FROM s1.v1 v1, s1.v1_ v2 WHERE v1.c1 = v2.c1;
1121 \! sql/maskout.sh results/ut-R.tmpout
1124 \o results/ut-R.tmpout
1125 /*+RowsHashJoin(r4t1 r4t1)*/
1126 EXPLAIN SELECT * FROM s1.r4 t1, s1.r4 t2 WHERE t1.c1 = t2.c1;
1128 \! sql/maskout.sh results/ut-R.tmpout
1130 \o results/ut-R.tmpout
1131 /*+RowsHashJoin(r4t1 r4t1)Rows(r4t1 r4t1 #1)*/
1132 EXPLAIN SELECT * FROM s1.r4 t1, s1.r4 t2 WHERE t1.c1 = t2.c1;
1134 \! sql/maskout.sh results/ut-R.tmpout
1137 \o results/ut-R.tmpout
1138 /*+NestLoop(r4t1 r5t1)*/
1139 EXPLAIN SELECT * FROM s1.r4 t1, s1.r5 t2 WHERE t1.c1 = t2.c1;
1141 \! sql/maskout.sh results/ut-R.tmpout
1143 \o results/ut-R.tmpout
1144 /*+NestLoop(r4t1 r5t1)Rows(r4t1 r5t1 #1)*/
1145 EXPLAIN SELECT * FROM s1.r4 t1, s1.r5 t2 WHERE t1.c1 = t2.c1;
1147 \! sql/maskout.sh results/ut-R.tmpout
1150 ---- No. R-2-4 VALUES clause
1154 \o results/ut-R.tmpout
1155 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
1157 \! sql/maskout.sh results/ut-R.tmpout
1159 \o results/ut-R.tmpout
1160 /*+ Leading(t3 t1 t2) Rows(t3 t1 #2)Rows(t3 t1 t2 #2)*/
1161 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
1163 \! sql/maskout.sh results/ut-R.tmpout
1165 \o results/ut-R.tmpout
1166 /*+ Leading(*VALUES* t1 t2) Rows(*VALUES* t1 #2)Rows(*VALUES* t1 t2 #20)*/
1167 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1;
1169 \! sql/maskout.sh results/ut-R.tmpout
1172 \o results/ut-R.tmpout
1173 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t4 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1 AND t1.c1 = t4.c1;
1175 \! sql/maskout.sh results/ut-R.tmpout
1177 \o results/ut-R.tmpout
1178 /*+ Leading(t4 t3 t2 t1) Rows(t4 t3 #2) Rows(t4 t3 t2 #2)Rows(t4 t3 t2 t1 #2)*/
1179 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t4 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1 AND t1.c1 = t4.c1;
1181 \! sql/maskout.sh results/ut-R.tmpout
1183 \o results/ut-R.tmpout
1184 /*+ Leading(*VALUES* t3 t2 t1) Rows(t4 t3 #2)Rows(*VALUES* t3 t2 #2)Rows(*VALUES* t3 t2 t1 #2)*/
1185 EXPLAIN SELECT * FROM s1.t1, s1.t2, (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t3 (c1, c2, c3, c4), (VALUES(1,1,1,'1'), (2,2,2,'2')) AS t4 (c1, c2, c3, c4) WHERE t1.c1 = t2.c1 AND t1.c1 = t3.c1 AND t1.c1 = t4.c1;
1187 \! sql/maskout.sh results/ut-R.tmpout
1194 \o results/ut-R.tmpout
1195 EXPLAIN SELECT max(bmt1.c1) FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
1197 \! sql/maskout.sh results/ut-R.tmpout
1199 \o results/ut-R.tmpout
1201 Leading(bmt4 bmt3 bmt2 bmt1)
1202 Rows(bmt1 bmt2 bmt3 bmt4 *0.7)
1204 EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
1206 \! sql/maskout.sh results/ut-R.tmpout
1209 \o results/ut-R.tmpout
1210 EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
1212 \! sql/maskout.sh results/ut-R.tmpout
1214 \o results/ut-R.tmpout
1216 Leading(bmt4 bmt3 bmt2 bmt1)
1217 Rows(bmt4 bmt3 *0.6)
1219 EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
1221 \! sql/maskout.sh results/ut-R.tmpout
1224 \o results/ut-R.tmpout
1225 EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
1227 \! sql/maskout.sh results/ut-R.tmpout
1229 \o results/ut-R.tmpout
1231 Leading(bmt4 bmt3 bmt2 bmt1)
1232 Rows(bmt4 bmt1 *0.5)
1234 EXPLAIN SELECT bmt1.c1 FROM s1.t1 bmt1, (SELECT ctid, * FROM s1.t2 bmt2) sbmt2, (SELECT ctid, * FROM s1.t3 bmt3) sbmt3, (SELECT ctid, * FROM s1.t4 bmt4) sbmt4 WHERE bmt1.c1 = sbmt2.c1 AND bmt1.c1 = sbmt3.c1 AND bmt1.c1 = sbmt4.c1;
1236 \! sql/maskout.sh results/ut-R.tmpout
1239 ---- No. R-3-1 abusolute value
1243 \o results/ut-R.tmpout
1245 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1247 \! sql/maskout.sh results/ut-R.tmpout
1250 \o results/ut-R.tmpout
1252 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1254 \! sql/maskout.sh results/ut-R.tmpout
1257 ---- No. R-3-2 increase or decrease value
1261 \o results/ut-R.tmpout
1263 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1265 \! sql/maskout.sh results/ut-R.tmpout
1268 \o results/ut-R.tmpout
1270 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1272 \! sql/maskout.sh results/ut-R.tmpout
1275 \o results/ut-R.tmpout
1276 /*+Rows(t1 t2 -1000)*/
1277 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1279 \! sql/maskout.sh results/ut-R.tmpout
1282 ---- No. R-3-3 multiple
1286 \o results/ut-R.tmpout
1288 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1290 \! sql/maskout.sh results/ut-R.tmpout
1293 \o results/ut-R.tmpout
1295 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1297 \! sql/maskout.sh results/ut-R.tmpout
1300 \o results/ut-R.tmpout
1301 /*+Rows(t1 t2 *0.1)*/
1302 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1304 \! sql/maskout.sh results/ut-R.tmpout
1307 ---- No. R-3-4 join inherit tables
1311 \o results/ut-R.tmpout
1312 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
1314 \! sql/maskout.sh results/ut-R.tmpout
1316 \o results/ut-R.tmpout
1318 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
1320 \! sql/maskout.sh results/ut-R.tmpout
1323 \o results/ut-R.tmpout
1324 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
1326 \! sql/maskout.sh results/ut-R.tmpout
1328 \o results/ut-R.tmpout
1329 /*+Rows(p1c1 p2c1 #1)*/
1330 EXPLAIN SELECT * FROM s1.p1, s1.p2 WHERE p1.c1 = p2.c1;
1332 \! sql/maskout.sh results/ut-R.tmpout
1335 ---- No. R-3-5 conflict join method hint
1339 \o results/ut-R.tmpout
1340 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1342 \! sql/maskout.sh results/ut-R.tmpout
1344 \o results/ut-R.tmpout
1345 /*+Rows(t1 t2 #1)Rows(t1 t2 #1)*/
1346 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1348 \! sql/maskout.sh results/ut-R.tmpout
1351 \o results/ut-R.tmpout
1352 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1354 \! sql/maskout.sh results/ut-R.tmpout
1356 \o results/ut-R.tmpout
1357 /*+Rows(t1 t2 #1)Rows(t1 t2 #1)Rows(t1 t2 #1)*/
1358 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1360 \! sql/maskout.sh results/ut-R.tmpout
1363 \o results/ut-R.tmpout
1364 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1366 \! sql/maskout.sh results/ut-R.tmpout
1368 \o results/ut-R.tmpout
1369 /*+Rows(t1 t2 #1)Rows(t2 t1 #1)*/
1370 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1372 \! sql/maskout.sh results/ut-R.tmpout
1375 \o results/ut-R.tmpout
1376 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1378 \! sql/maskout.sh results/ut-R.tmpout
1380 \o results/ut-R.tmpout
1381 /*+Rows(t2 t1 #1)Rows(t1 t2 #1)Rows(t2 t1 #1)*/
1382 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1384 \! sql/maskout.sh results/ut-R.tmpout
1387 ---- No. R-3-6 hint state output
1391 SET client_min_messages TO DEBUG1;
1392 \o results/ut-R.tmpout
1393 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1395 \! sql/maskout.sh results/ut-R.tmpout
1397 \o results/ut-R.tmpout
1399 EXPLAIN SELECT * FROM s1.t1, s1.t2 WHERE t1.c1 = t2.c1;
1401 \! sql/maskout.sh results/ut-R.tmpout
1402 \! rm results/ut-R.tmpout