What is content indexing/full text indexing?

• A full text index indexes the entire XML instance and ignores the values, nodes and other XML syntax.
• Only one content index is allowed per table.
• A content index is applied to a column and not a table.
• When an XMl index is applied, the index is applied first and then the XQuery is applied. For a table to which a content index is applied, a unique primary key column must already have been defined on the table for which the index is created. 

<<Previous   Next>>