SELECT t1.id,t1.Name
FROM Table1 as t1 --800,000 records
INNER JOIN Table2 as t2 --500,000 records
ON t1.fkID = t2.id
INNER JOIN Table3 as t3 -- 1,000 records
ON t1.OtherId = t3.id

如果我在Table2和Table3上更改了联接的顺序,我会看到性能提升吗？见下文：

SELECT t1.id,000 records
INNER JOIN Table3 as t3 -- 1,000 records
ON t1.OtherId = t3.id
INNER JOIN Table2 as t2 --500,000 records
ON t1.fkID = t2.id

我听说查询优化器会尝试确定最佳订单,但并不总是有效.您使用的sql Server版本是否有所不同？