oceanbase
10 строк · 320.0 Байт
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## partition wise join
8explain select /*+ USE_PX parallel(2) */ * from stu, score where stu.sid = score.sid;
9--sorted_result
10select /*+ USE_PX parallel(2) */ * from stu, score where stu.sid = score.sid;
11
12
13