创建视图的SQL语句太长，且用视图查看数据的查询速度太慢，想知道如何优化提高查询速度

创建视图的SQL语句太长，且用视图查看数据的查询速度太慢

CREATE VIEW [……]  AS (
(SELECT  t.*
FROM     ((SELECT  table.*, row_number() OVER (partition BY [……]]
                ORDER BY [……]] DESC) AS rm
FROM     table
WHERE   Id = '111'))  as t
WHERE   t.rm = 1)
UNION ALL
(SELECT  t.*
FROM     ((SELECT  table.*, row_number() OVER (partition BY [……]]
                ORDER BY [……]] DESC) AS rm
FROM     table
WHERE   Id = '112'))  as t
WHERE   t.rm = 1)
UNION ALL 
(SELECT  t.*
FROM     ((SELECT  table.*, row_number() OVER (partition BY [……]]
                ORDER BY [……]] DESC) AS rm
FROM     table
WHERE   Id = '113'))  as t
WHERE   t.rm = 1)
UNION ALL 
(SELECT  t.*
FROM     ((SELECT  table.*, row_number() OVER (partition BY [……]]
                ORDER BY [……]] DESC) AS rm
FROM     table
WHERE   Id = '114'))  as t
WHERE   t.rm = 1)
UNION ALL 
(SELECT  t.*
FROM     ((SELECT  table.*, row_number() OVER (partition BY [……]]
                ORDER BY [……]] DESC) AS rm
FROM     table
WHERE   Id = '115'))  as t
WHERE   t.rm = 1))

想提高查询速度

把完整sql拿出来，还有各个表的数据量、索引、分区，再看下执行计划。光看你这个伪代码没有意义