Re: suggestions for implementing heavily used log tables with nightly delete

2001-03-19 Thread Jeremy D. Zawodny
On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote: Got any suggestions on how these could be implemented? particular table types/setups/etc? I basically have a situation where 300,000+ rows are being inserted into a log table daily, and also needing to be cleared out

RE: suggestions for implementing heavily used log tables with nightly delete

2001-03-19 Thread Neulinger, Nathan R.
Ok. The second one below sounds semi reasonable - it does mean that the table will be somewhat useless for queries during the delete, but that's not tragic. Is there any way to drop all the indexes on a table with a single statement? Third one sounds good as well, but unfortunately, there is a