我的IN子句导致在T-SQL中完全扫描索引.我能做什么？

SELECT * FROM table1 WHERE column1 IN (SELECT column2 FROM table2)

SELECT DISTINCT t1.* FROM table1 t1 JOIN table2 t2 ON t1.column1 = t2.column2

SELECT * FROM table1 WHERE column1 IN ('value1', 'value2', 'value3')

SELECT * FROM table1 WHERE column1 = 'value1'
UNION ALL SELECT * FROM table1 WHERE column1 = 'value2'
UNION ALL SELECT * FROM table1 WHERE column1 = 'value3'

DECLARE @value INT = 1
SELECT * FROM table1 WHERE column1 = @value

DECLARE @value INT = 1
SELECT * FROM table1 WITH (OPTION (RECOMPILE)) WHERE column1 = @value