Re: The Fastest Way To Delete All Rows In A Table

>The reason is that the next day, the table will fill up again and so I want >the query optimiser to behave as though the table has many rows, not zero >rows. Ye-ouch! Are you saying that your data has such little variation in content? Why not just leave the data intact every day then? You can save the time to delete, populate and update statistics that way! :-) >I could run UPDATE STATISTICS the following day but timing it is tricky. If >its run too early then the information gathered is not significant, if its >run too late, the application accessing the database will have been >performing badly. Fair enough. But if your distributions vary then it doesn't help having the wrong distributions either... :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com