Top与Rank/Row Number函数-哪个函数的性能更高?

我试图在谷歌上搜索在查询中使用Top与使用Ranking或Row_Number类型函数的成本。

每种功能的成本是否取决于情况,或者这两种功能的价格是否可以在所有情况下全面确定?

下面是一些模拟SQL,使用一个简单的CTE来演示我的问题,如下所示:

WITH fData AS
(
    SELECT 1 AS ID, 'John' AS fName, 'Black' AS lName, CAST('05/19/1975' AS DATE) AS birthDate UNION ALL
    SELECT 2 AS ID, 'John' AS fName, 'Black' AS lName, CAST('04/1/1989' AS DATE) AS birthDate UNION ALL
    SELECT 3 AS ID, 'John' AS fName, 'Black' AS lName, CAST('11/16/1995' AS DATE) AS birthDate UNION ALL
    SELECT 4 AS ID, 'John' AS fName, 'Black' AS lName, CAST('01/16/1968' AS DATE) AS birthDate UNION ALL
    SELECT 5 AS ID, 'John' AS fName, 'Black' AS lName, CAST('01/16/1968' AS DATE) AS birthDate
)   

/* Using TOP 1 vs Row_Number() - Uncomment this and comment the below to VIEW TOP version */
--SELECT TOP 1 d.ID, d.fName, d.lName, d.birthDate
--FROM fData d
--ORDER BY d.birthDate

/* Using the below vs TOP 1 */
SELECT * FROM
(   SELECT d.ID, d.fName, d.lName, d.birthDate, Row_Number() OVER (ORDER BY d.birthDate) AS ranker
    FROM fData d
) r
WHERE r.ranker = 1

当使用TOP时,不需要在它周围应用第二个Wrapping查询,它看起来更干净。在应用Row_Number或Ranking函数后,您必须将其包装以告诉查询您现在想要的是哪一行。。。通过应用WHERE ranker=1或ranker>=5以实现与TOP 1或TOP 5相同的效果。

如果这是可以确定的,哪一个更好更快?