January 8, 2012 at 9:06 am
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
January 8, 2012 at 9:27 am
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
January 8, 2012 at 9:44 am
Oke thanx, can you tell me (point me to a source) how to disable en reload them?
January 8, 2012 at 9:45 am
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
January 8, 2012 at 10:06 am
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