SQL Server Performance

Full Text Catalog

Discussion in 'SQL Server 2005 General DBA Questions' started by Raj1979, Jun 30, 2006.

  1. Raj1979 New Member

    Hi,

    Can someone give me a detailled explanation of what is the difference between the below two in SQL Server 2005

    1. Setting the Full Text index/ catalog to auto track the changes
    2. Right clicking on a table that is full text indexed and go to Full text index --> and "start incremental population"

    Also when you run the select statement
    select * from sys.fulltext_indexes

    I would want to know what is Crawl_type (or ) crawl_desc and when it changes from F to I or from I to F. and what is the impact?

    Thanks

Share This Page