如何解决SQL Server - 基于参数的内联表值函数执行计划变化？

SELECT * FROM dbo.MyInlineFunction(@param) OPTION (RECOMPILE);

-- 启用强制参数化
EXEC sp_executesql N'SELECT * FROM dbo.MyInlineFunction(@param)', N'@param INT', @param = @param;

CREATE FUNCTION dbo.MyInlineFunction (@param1 INT, @param2 INT)
RETURNS TABLE
AS
RETURN
(
    SELECT * FROM dbo.MyTable WHERE col1 = @param1 AND col2 = @param2
);

CREATE FUNCTION dbo.MyInlineFunction (@param INT)
RETURNS @Results TABLE
(
    col1 INT,
    col2 VARCHAR(50)
)
AS
BEGIN
    INSERT INTO @Results
    SELECT col1, col2 FROM dbo.MyTable WHERE col1 = @param;
    RETURN;
END;