Maintaining a Full Text index

All replies

• 

  

  0

  Sign in to vote

  Hello All, 

  I am working on Full Text indexes maintenance. I have couple of question, which will be helpful for me to understand the Full text indexes. 

  1. What is populating a Full Text index ? Is Populating different from Rebuilding a Index ?

  2. What is the suggested maintenance for Full text ? Like- having a job to rebuild the FT Index every week or how to schedule ?

  3. Does the normal table Rebuild index job takes care of rebuilding a FT Index ?

  
  

  • Merged by Lydia ZhangMicrosoft contingent staff Thursday, July 7, 2016 1:39 AM duplicate

  Wednesday, July 6, 2016 4:00 PM
• 

  

  0

  Sign in to vote

  Hello,

  1. It's similar, but a full text index is "populated" (updated) asynchron with the data, while update of index data is synchron.

  2. See Populate Full-Text Indexes; with option "Change Tracking-Based Population" the Fts index is maintained automatically.

  3. No, see 2.

  ---

  Olaf Helper

  [ Blog] [ Xing] [ MVP]

  • Proposed as answer by Lin LengMicrosoft contingent staff Sunday, July 17, 2016 12:57 PM
  • Marked as answer by Lydia ZhangMicrosoft contingent staff Monday, July 18, 2016 2:02 AM

  Wednesday, July 6, 2016 5:06 PM
• 

  

  0

  Sign in to vote

  Double post: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a3b021ca-5433-4fc5-be91-3a1cc8ae2ca9/maintaining-a-full-text-index?forum=sqlkjmanageability

  ---

  Olaf Helper

  [ Blog] [ Xing] [ MVP]

  Wednesday, July 6, 2016 5:06 PM