select * from [Большая Таблица] where ID IN(1,2,3,...)
select T.* from [Большая Таблица] T INNER JOIN ( select 1 as ID UNION select 2 UNION select 3 ...) TI ON T.ID = TI.ID