September 4, 2003 at 4:30 am
Hi,
I would appreciate any recommendations on a situation when a table will be frequently truncated of all records and new rows will be added to it. This process will occur on the table once every hour. I was just wondering if there are any guidelines (like proper indexes, recomplication of the SP for regeneration of the execution plan, reindexing etc.). The table has a PK and varchar fields with lots of text in it. I'm running SQL Server 2000.
Thanks!
September 4, 2003 at 4:58 am
How many records get loaded and how frequently is the table accessed.
Can do update stats, etc. after load.
September 4, 2003 at 5:31 am
Around 15,000+ records get loaded on each run (records are inserted from another table as part of a transaction in a SP) and the table will be accessed by a web application (multi-user environment).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply