Which is Better? -- sql server full text search

John Cantley
3/22/2007 12:00:00 AM

Which is better to index. A view that pulls in all the fields I need and
indexing the view or indexing the tables I need and then merge the indexes.
I am looking for performance here. I have about 6 different tables that I am
joining in the view and only gettting the fields I need.

Thanks,
jc

Hilary Cotter
3/22/2007 12:46:14 PM

Under SP2 the view should be a better option. In prior versions you should
build a composite table for such a query.

--
Hilary Cotter

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

[quoted text, click to view]

sql server full text search : Which is Better?