SQL Server Performance

what is incremental population and fetch

Discussion in 'Getting Started' started by vkkishore_s, Sep 27, 2007.

  1. vkkishore_s New Member

    Hai Friends
    can anybody tell me what is ment by incremental population and fetch.Please share your knowledge with me.
    Thanks and Regards
    Charlie
  2. satya Moderator

    Welcome to the forum!
    I believe that sounds like an interview question, have you referred through web in this regard?
    Incremental population varies in different sections of SQL Server, for instance within the fulltext indexing it only adjusts index entries for rows that have been added, deleted, or modified after the last population.
    Incremental population requests are implemented as full populations if any of the metadata for the table has changed since the last population. This includes altering any column, index, or full-text index definitions.
    Mostly I believe that will go with FULLTEXT Indexing.

Share This Page