Post reply

Full-text index

  • October 25, 2006 at 8:10 am

    #62221

    Hi All,

    Does rebuilding of indexes on a table also rebuilds/reorganizes full-text indexes?

    Thanks!

  • October 25, 2006 at 8:49 am

    #667887

    No, full-text indexes and catalogs must be explicitly rebuilt.  There is no connection between performance indexes and full-text indexes.

    Greg 

    Greg

  • October 25, 2006 at 4:44 pm

    #668041

    except if explicitly enabled track changes in the background? Thanks, Dex

  • October 25, 2006 at 5:25 pm

    #668051

    That will update the full-text index if the data in the referenced columns changes, but not if you add or remove a performance index.

    Greg

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply