Full text index in Azure SQL DB RRS feed

  • Question

  • HI,

    I have started using the Full text index in Azure SQL DB. I am using SSIS to load/refresh the database. Generally, during loading, we disable the indexes, load and then re-enable the indexes for better load performance. Does this apply for Full-Text index in Azure SQL as well? The table with the full-text indexing will be truncated and reloaded everyday.

    Currently, the approach I am following is, drop the foreign key constraints, truncate the tables, alter to include the foreign key constraints. I am not dropping/disabling the Unique key (identity column) I have created for the sole purpose of the full text index since my primary key is a varchar.

    What would be a good approach for this.




    • Merged by Girish Prajwal Thursday, June 4, 2015 5:16 PM Same issue
    • Split by Girish Prajwal Thursday, June 4, 2015 6:00 PM merged with wrong queue
    Thursday, June 4, 2015 3:59 PM


All replies

  • Hi NewBeeMS,

    Thanks for posting here.

    We are looking into this issue and will soon revert back with suggestions. Stay tuned for details.

    Girish Prajwal

    Thursday, June 4, 2015 6:02 PM
  • Pause populating the full-text index during load helps crawl to pause and improves the load performance. Post load you can resume the population. Syntax for this can be referred @ https://technet.microsoft.com/en-us/library/ms188359(v=sql.110).aspx

    Look for {STOP | PAUSE | RESUME } POPULATION options.

    • Proposed as answer by Joseph Idziorek Thursday, June 4, 2015 9:17 PM
    • Marked as answer by NewBeeMS Friday, June 5, 2015 1:19 PM
    Thursday, June 4, 2015 6:20 PM
  • Thanks, Narlapurams.


    Friday, June 5, 2015 1:20 PM