locked
Full text index in Azure SQL DB RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thanks,

    Arul


    Arul

    • 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

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks, Narlapurams.

    Arul

    Friday, June 5, 2015 1:20 PM