大数据计算服务MaxCompute的SQL语句支持Join操作,在Join语句中Where条件的位置对SQL语句的执行效率有较大的影响,下列语句中不被推荐的是_____.
选项:
A:
select * from A join (select * from B where dt=20150301)B on
B:id=
A:id where
A:dt=20150301;
B:
select * from A join B on
B:id=
A:id where
B:dt=20150301;
C:
select * from (select* from A where dt=20150301)A join (select * from B where dt=20150301)B on
B:id=
A:id;
D:
select * from A join B on
B:id=
A:id where
B:dt=20150301 and
A:dt=20150301;