如何重写交叉应用到内部联接以使视图索引

在 separate thread

Name     Orders
'John'   New Hat, New Book, New Phone
'Marry'  NULL

我需要为视图编制索引,但如果视图中的SELECT查询已应用和/或子查询,则无法执行此操作。是否可以将此视图转换为索引视图?

create table Customers (CustomerId int, CustomerName VARCHAR(100))
create table Orders    (CustomerId int, OrderName VARCHAR(100))

insert into Customers  (CustomerId, CustomerName) select 1, 'John' union all select 2, 'Marry'
insert into Orders     (CustomerId, OrderName)    select 1, 'New Hat' union all select 1, 'New Book' union all select 1, 'New Phone'
go

create view OrderView as 
select c.CustomerName, x.OrderNames        
from Customers c            
cross apply (select stuff((select ',' + OrderName from Orders o 
      where o.CustomerId = c.CustomerId for xml path('')),1,1,'') 
      as OrderNames) x
go