Re: Delete time
From: David E. Zuzga <dzuzga_at_interaccess>
Date: 19 May 1994 00:48:18 GMT
Message-ID: <2red0i$piq_at_mailhost.interaccess.com>
Date: 19 May 1994 00:48:18 GMT
Message-ID: <2red0i$piq_at_mailhost.interaccess.com>
Scott T Johnson (sarek_at_cais.com) wrote:
: Hi all, I have an Oracle7 database. THere are tables that contain about
: 10000 records that have to be deleted. This takes over a minute to do.
: Dropping the table is much faster but not an option. Can this time be cut
: down by some type of tuning? Scott
Try the 'truncate table' command. Deletes all the rows in the table quickly, but does not drop the table. Syntax is:
truncate table <table name>;
Dave Zuzga (dzuzga_at_interaccess.com) Received on Thu May 19 1994 - 02:48:18 CEST