Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Left Join Table2 B on A.cInstrID = B.cID
where B.cName like '%三槽式冷热冲击试验箱%'
order by A.iAutoID desc
原SQL语句: Select top 10 A.*, B.cName as cInstrName, B.cModel From Table1 A Left Join Table2 B on A.cInstrID = B.cID where B.cName like '%三槽式冷热冲击试验箱%' order by A.iAutoID desc 说明: 1、A表有自增主键 iAutoID, 非聚集索引cInstrID 等 2、B表有 非聚集索引cID 等 3、A表总数据行数:35000,B表总数据行
如果你只取 top 10的话
这样应该更快
Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Inner Join (select top 10 cID,cName ,cModel From Table2 B where cName like '%三槽式冷热冲击试验箱%' ) on A.cInstrID……
[/Quote]
Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Inner Join (select cID,cName ,cModel From Table2 B where cName like '%三槽式冷热冲击试验箱%' ) on A.cInstrID = B.cID
如果你只取 top 10的话
这样应该更快
Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Inner Join (select top 10 cID,cName ,cModel From Table2 B where cName like '%三槽式冷热冲击试验箱%' ) on A.cInstrID = B.cID
Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Inner Join (select cID,cName ,cModel From Table2 B where cName like '%三槽式冷热冲击试验箱%' ) on A.cInstrID = B.cID
[/Quote]
Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Inner Join (select cID,cName ,cModel From Table2 B where cName like '%三槽式冷热冲击试验箱%' ) on A.cInstrID = B.cID
--试下这样查 是不是快点?
Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Left Join Table2 B on A.cInstrID = B.cID
where B.cName like '%三槽式冷热冲击试验箱%'
[/Quote]
--试下这样查 是不是快点?
Select top 10 A.*, B.cName as cInstrName, B.cModel
From Table1 A
Left Join Table2 B on A.cInstrID = B.cID
where B.cName like '%三槽式冷热冲击试验箱%'