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