求助大神帮优化下SQL语句，老是提示超时

[linliang127]

SELECT * FROM (SELECT [UserId],[UserBalance],[TotalAmount],[MissionAmount],[ToCardAmount],[UserGoldCoinBalance],[TotalGoldCoinAmount],[CreditScore],[CreatedAt],[CreatedUserId],[UpdatedAt],[UpdatedUserId],ROW_NUMBER() OVER(ORDER BY GETDATE() ) AS RowIndex FROM [UserAccount] WITH(NOLOCK) WHERE ( [UserId] = @UserId0 )) T WHERE RowIndex BETWEEN 1 AND 1

[Hello World,]

取随机记录？ UserId应该有索引的吧

SELECT      TOP(1)  [UserId],
                    [UserBalance],
                    [TotalAmount],
                    [MissionAmount],
                    [ToCardAmount],
                    [UserGoldCoinBalance],
                    [TotalGoldCoinAmount],
                    [CreditScore],
                    [CreatedAt],
                    [CreatedUserId],
                    [UpdatedAt],
                    [UpdatedUserId],
                    NEWID() AS RowIndex
FROM        [UserAccount] WITH(NOLOCK)
WHERE       ([UserId] = @UserId0)
ORDER BY    RowIndex;

[linliang127]

非常感谢版主的及时回复，目前已处理，特别感谢！

[吉普赛的歌]

-- UserId 是主键，只可能取一条记录出来，不需要那么多限制，越简单越好。
SELECT [UserId],
       [UserBalance],
       [TotalAmount],
       [MissionAmount],
       [ToCardAmount],
       [UserGoldCoinBalance],
       [TotalGoldCoinAmount],
       [CreditScore],
       [CreatedAt],
       [CreatedUserId],
       [UpdatedAt],
       [UpdatedUserId]
FROM   [UserAccount] WITH(NOLOCK)
WHERE  [UserId] = @UserId

[jiepangK]

为什么要ORDER BY GETDATE() 呢，不直接order by userId