Each full-text index indexes one or more columns from the table, and each column can use a specific language.

XML uses large object storage which uses varchar(max) and varbinary(max).

Full-text queries perform linguistic searches against text data in full-text indexes.

Different XML choices may also have different performance characteristics.

In order to make the query execution efficient, we create indexes.

sys.dm_db_index_physical_stats provides information, such as the number of disk pages occupied, average row size in bytes, and number of records, for all index types.

The DROP INDEX (Transact-SQL) Transact-SQL statement can be used to drop existing primary or secondary XML and non-XML indexes.

Within the FOR XML clause,we specify an XML mode: RAW, AUTO, EXPLICIT or PATH.

Secondary indexes are PATH, VALUE, and PROPERTY.

A QName is made up of a namespace prefix and a local name. In this implementation, the variable names in XQuery are QNames and they cannot have prefixes.