combinational index with XML fields

• G33kKahuna

  SSCommitted

  Points: 1726

  More actions

  September 24, 2008 at 9:08 am

  #96544

  is there a way to create a combinational index with regular field in the table and an element in the XML?

  For ex:

  CREATE TABLE Employee (EmpId INT, EmpXml XML)

  INSERT INTO Employee(EmpId, EmpXml) VALUES

  (1,'<Employee><FirstName>John</FirstName><LastName>Doe</LastName></Employee>')

  Is there a way to index EmpId, FirstName and LastName?

  thanks

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  September 25, 2008 at 10:55 am

  #877181

  I am curious to know too

  Would guess NO though

  Even if you create a view that XQuery the elements as a column

  I don't know if you can SCHEMABIND it and create a clustered index on it, but you might be able to create a NONCLUSTERED index on it

  Why is there a need to index on particular elements in the XML?

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005