有两个view A和B和一个表job
他们有共同的4个key a1,a2,a3,a4
现在需要把他们做连接然后做成另外一个view,这个新view的sql大致的样子是
select
job.nn,
job.mm,
job.kk
A.x
B.y
from job,A,B
where
job.a1=A.a1
and job.a2=A.a2
and job.a3=A.a3
and job.a4=A.a4
and job.a1=B.a1
and job.a2=B.a2
and job.a3=B.a3
and job.a4=B.a4
但是他们的数据都非常多,导致连接巨慢,请问该怎么优化呢?多谢了
他们有共同的4个key a1,a2,a3,a4
现在需要把他们做连接然后做成另外一个view,这个新view的sql大致的样子是
select
job.nn,
job.mm,
job.kk
A.x
B.y
from job,A,B
where
job.a1=A.a1
and job.a2=A.a2
and job.a3=A.a3
and job.a4=A.a4
and job.a1=B.a1
and job.a2=B.a2
and job.a3=B.a3
and job.a4=B.a4
但是他们的数据都非常多,导致连接巨慢,请问该怎么优化呢?多谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货