DTA questions

  • Hi,

    I have used DTA to analyze my queries (tables) and it suggested some indexes to create. After doing so there is a visible performance change (better I mean). Also the used resources are much lower.

    Most indexes are created on a table with over 350.000 items. Every night I do a "truncate table" to empty this table. Then I use an import to insert new products from xml feeds.

    The question I have is if I need to recreate after each import the indexes. Or will they still exists after a truncate and a new import of products?

    thanx for the time

    Walther

  • The indexes will still exist. For performance of the load you may want to disable them before the truncate and load and rebuild them afterwards

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Oke thanx, can you tell me (point me to a source) how to disable en reload them?

  • Sure. Books Online (the SQL help file). ALTER INDEX ... DISABLE and ALTER INDEX ... REBUILD.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • merci I will find it so

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply