T-SQL，视图中重复的相同标量子查询性能

WITH CTE_Name AS (
    SELECT ColumnName
    FROM TableName
    WHERE Condition
)
SELECT ColumnName, (SELECT ColumnName FROM CTE_Name WHERE Condition) AS SubqueryResult
FROM Table1;

CREATE FUNCTION dbo.FunctionName()
RETURNS INT
AS
BEGIN
    RETURN (SELECT ColumnName FROM TableName WHERE Condition);
END;
GO

SELECT ColumnName, dbo.FunctionName() AS SubqueryResult
FROM Table1;

CREATE VIEW View_Name
WITH SCHEMABINDING
AS
SELECT ColumnName, (SELECT ColumnName FROM TableName WHERE Condition) AS SubqueryResult
FROM Table1;
GO

CREATE UNIQUE CLUSTERED INDEX IX_View_Name ON View_Name (ColumnName);