34,594
社区成员
发帖
与我相关
我的任务
分享如何提升多表联合查询的速度？
表Trade有33万条数据，
表Member有3万
查询一条商机数据的时候，怎样优化Sql?
以下是我的写法，有没有更好的？
SELECT Trade.*,Member.CompanyName
FROM Trade , Member
WHERE ID = 168888
AND Trade.MemberID = Member.MemberID
表Member有3万
查询一条商机数据的时候，怎样优化Sql?
以下是我的写法，有没有更好的？
SELECT Trade.*,Member.CompanyName
FROM Trade , Member
WHERE ID = 168888
AND Trade.MemberID = Member.MemberID
...全文
请发表友善的回复…
发表回复
flyfish51f 2004-12-28
- 打赏
- 举报
用 inner join 能提升多少？
long0104 2004-12-28
- 打赏
- 举报
SELECT Trade.*,Member.CompanyName
FROM Trade inner join Member on Trade.MemberID = Member.MemberID
WHERE ID = 168888
FROM Trade inner join Member on Trade.MemberID = Member.MemberID
WHERE ID = 168888
---涛声依旧--- 2004-12-28
- 打赏
- 举报
SELECT Trade.*,Member.CompanyName
FROM Trade inner join Member on Trade.MemberID = Member.MemberID
WHERE ID = 168888
FROM Trade inner join Member on Trade.MemberID = Member.MemberID
WHERE ID = 168888
RainYang 2004-12-28
- 打赏
- 举报
inner join
