oceanbase

1
#owner: dachuan.sdc
2
#owner group: SQL3
3
# tags: optimizer
4

5
--source mysql_test/test_suite/px/include/exam_data.inc
6

7
## hash - hash dist,hash dist
8
explain select /*+ USE_PX parallel(2) */ * from score, teacher where teacher.subject = score.subject;
9
--sorted_result
10
select /*+ USE_PX parallel(2) */ * from score, teacher where teacher.subject = score.subject;
11

12
# 老师名下的年级考试平均分, hash dist, hash join, hash group by
13
explain select /*+ USE_PX parallel(2) */ teacher.name, teacher.subject, avg(score) from score, teacher where teacher.subject = score.subject group by teacher.name, teacher.subject;
14
--sorted_result
15
select /*+ USE_PX parallel(2) */ teacher.name, teacher.subject, avg(score) from score, teacher where teacher.subject = score.subject group by teacher.name, teacher.subject;
16

17