SELECT *
FROM dbo.mmImportOrderDtl iod
JOIN dbo.mmImportOrderHdr ioh ON iod.ummImportOrderHdrId=ioh.ummImportOrderHdrId AND iod.bUse=1 AND ioh.bUse=1
JOIN dbo.mesColour c ON c.uColourId=iod.uColourId
where ioh.sOrderNo='422576-5656'使用以上者条语句查询速度很快,不到1SSELECT c.sColourCNName
FROM dbo.mmImportOrderDtl iod
JOIN dbo.mmImportOrderHdr ioh ON iod.ummImportOrderHdrId=ioh.ummImportOrderHdrId AND iod.bUse=1 AND ioh.bUse=1
JOIN dbo.mesColour c ON c.uColourId=iod.uColourId
where ioh.sOrderNo='422576-5656'同样的只是输出的字段减少为一个了,查询速度倒是变成34S求大神指点,从来没有遇到过这种情况,数据表中只有主键有索引,其他什么都没有做
FROM dbo.mmImportOrderDtl iod
JOIN dbo.mmImportOrderHdr ioh ON iod.ummImportOrderHdrId=ioh.ummImportOrderHdrId AND iod.bUse=1 AND ioh.bUse=1
JOIN dbo.mesColour c ON c.uColourId=iod.uColourId
where ioh.sOrderNo='422576-5656'使用以上者条语句查询速度很快,不到1SSELECT c.sColourCNName
FROM dbo.mmImportOrderDtl iod
JOIN dbo.mmImportOrderHdr ioh ON iod.ummImportOrderHdrId=ioh.ummImportOrderHdrId AND iod.bUse=1 AND ioh.bUse=1
JOIN dbo.mesColour c ON c.uColourId=iod.uColourId
where ioh.sOrderNo='422576-5656'同样的只是输出的字段减少为一个了,查询速度倒是变成34S求大神指点,从来没有遇到过这种情况,数据表中只有主键有索引,其他什么都没有做
192.168.0.2服务器用户表也有1000万条数据我想通过sql语句把两个表连接起来,这岂不就是相当于分布式数据库了吗?请问有没有这样的sql语句?