November 11, 2003 at 1:43 pm
How can I improve the speed of indexing a full text enabled table? there is only one column for indexing, but 1.6 mio records.
we have 4 processors, 5.5 gb ram
what can i do, to create this index faster?
thanks for your answer
urs
November 11, 2003 at 9:00 pm
Hi there
Are you rebuilding all the time?? are you doing incrementals?? (timestamp col on table?). The build is slow, CPU intensive and I havent found a method to speed it substantially. Try http://www.sql-server-performance.com or MS technet for some article related to speed, some interesting points I cant remember btu well worth the look. With you server spec what are you experiencing in terms of time?
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
November 12, 2003 at 1:11 am
hi chris
no, we don't rebuilt it everytime. change tracking /update in background
we added a new column (not an index column) to the table and then the index has to rebuilt. this is really a mess, why must a index rebuilt, when i add a column which is not indexed??? could you explain me that?
must be there a timestamp column also, when i'm not doing it incremental?
thanks
urs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply