Re: Delete time
From: Andy Finkenstadt <genie_at_panix.com>
Date: 18 May 1994 21:45:11 -0400
Message-ID: <2regb7$gqv_at_panix.com>
Date: 18 May 1994 21:45:11 -0400
Message-ID: <2regb7$gqv_at_panix.com>
In <2re7pj$2hu_at_sun.cais.com> sarek_at_cais.com (Scott T Johnson) writes:
>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
TRUNCATE TABLE schema.table_name;
Andy
-- andy_at_genie.geis.com | Andy Finkenstadt, GEnie Sysop, GEnie Postmaster andy_at_tml.com | Systems Engineer, TML Information Services, Inc. genie_at_panix.com | +1 718-793-9099Received on Thu May 19 1994 - 03:45:11 CEST