Re: Full Text Indexing Performance?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

What I mean is that my table has many columns. One of the columns is
called 'Description'. If I instead make a table called 'Description'
and put the 'Description' column in that table and make a foreign key
relationship to the parent table, will query speed improve?

Another way to ask my 'linked server question' is:

ServerA has NamedInstanceA and DatabaseA with the table that needs
full-text indexing. Would there be any benefit to making
ServerA/NamedInstanceB/DatabaseB and using Linked Servers somehow to
get the full text engine working on a different instance?

Thanks.



On Tue, 12 May 2009 05:50:06 GMT, v-fathan@xxxxxxxxxxxxxxxxxxxx (Mark
Han[MSFT]) wrote:



2 according to your description, i'm not very clear about "Create another
databaseon the same server and do a Linked Server? Keep everything in one
index? Move each "important" column to its own table?". in order to better
assist you with the issue, could you describe the above in detail?

Besides, about the Performance Tuning and Optimization (Full-Text Search),
there is an article to share with
you:http://msdn.microsoft.com/en-us/library/ms142560(SQL.90).aspx



.