You are the database administrator for your company. One of the databases that you maintain contains largevolumes of XML data.
An XML column appears in the WHERE clauses of most queries that users execute againstthe database.
The large binary objects (BLOBs) are shredded at runtime for each row of the query.
This processbecomes very expensive for the database server in terms of resources and performance.
In this scenario, you decide to create an index on the XML columns.
You need to ensure that you understand XML indexes.
Which statements about XML indexes are true? (Choose all that apply.)