SQL full text indexing / indexed view?

Question

Can sql full text index a text column on an indexed view?

Answer 1

Hello,

For a full text index a unique index as reference is required, so if there is a unique index on the view then you can create also a full text index on it.

See also CREATE FULLTEXT INDEX (Transact-SQL) => Arguments:

table_name                                

Is the name of the table or indexed view that contains the column or columns included in the full-text index.

It documented and fully supported.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Hello,

For a full text index a unique index as reference is required, so if there is a unique index on the view then you can create also a full text index on it.

See also CREATE FULLTEXT INDEX (Transact-SQL) => Arguments:

table_name                                

Is the name of the table or indexed view that contains the column or columns included in the full-text index.

It documented and fully supported.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Olaf, does it matter if the index on the view is clustered or non-clustered?  Is one more preferable?

scott