Page 1 of 1

Question re: updating a full-text index

Posted: Sat Feb 26, 2005 3:47 pm
by voltrader
I've been keeping my full-text index updated by emptying it, and rebuilding it using

Code: Select all

insert INTO full-text_index
SELECT c1, c2, c3
FROM temp_stuff
Can use an UPDATE instead for a full-text index?

Posted: Sat Feb 26, 2005 6:26 pm
by Joe
I am sure you could use aliases to achieve what you desire?.

Posted: Sat Feb 26, 2005 8:59 pm
by voltrader
Pretty cryptic response Joe... :?:

Let me elaborate: I often have updates in another table that need to be inserted into the fulltext table for search purposes. I currently empty and then rebuild my full-text search index in the dead of night because I don't want my db to be offline during busier times. Is there no other way than to empty and then rebuild?

That seems kludgy.

Posted: Sat Feb 26, 2005 9:02 pm
by feyd
what's wrong with making the "source" table have full-text indexes on those fields?