Files
oceanbase/test/mysql_test/test_suite/px/t/join_pwj.test
oceanbase-admin cea7de1475 init push
2021-05-31 22:56:52 +08:00

10 lines
263 B
Plaintext

--source mysql_test/test_suite/px/include/exam_data.inc
## partition wise join
explain select /*+ USE_PX parallel(2) */ * from stu, score where stu.sid = score.sid;
--sorted_result
select /*+ USE_PX parallel(2) */ * from stu, score where stu.sid = score.sid;