Order of full-text indexing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

almurph@altavista.com - 14 Jun 2006 15:46 GMT

Hi,

Should I build a full-text index on a field before or after I create a
non-clustered index on that field. Or does it matter?

Al.

Reply to this Message

Hilary Cotter - 14 Jun 2006 19:38 GMT

Before is better. Creating the index after will in some cases cause a full
population.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
> Should I build a full-text index on a field before or after I create a
> non-clustered index on that field. Or does it matter?
>
> Al.

Reply to this Message