Full text

  • 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

  • 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

    http://www.chriskempster.com

    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"

  • 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