是否可以从Sql Server 2008中的Xml Data创建索引视图？

CREATE TABLE MyTable (
    id INT PRIMARY KEY,
    xml_data XML
);

CREATE VIEW MyIndexedView WITH SCHEMABINDING AS
SELECT
    id,
    xml_data.value('(/root/element1)[1]', 'int') AS element1,
    xml_data.value('(/root/element2)[1]', 'varchar(100)') AS element2
FROM MyTable;

CREATE UNIQUE CLUSTERED INDEX idx_MyIndexedView ON MyIndexedView (id);