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
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