Xref: alice comp.databases.oracle.server:75345
Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!newsfeed.nacamar.de!fu-berlin.de!uni-berlin.de!195.88.151.190!not-for-mail
From: "Kathinka Diehl" <kathinka@rrr.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Delete performance
Date: Wed, 24 Nov 1999 12:36:28 +0100
Lines: 16
Message-ID: <81giu2$1ofuh$1@fu-berlin.de>
References: <5HP_3.584$F01.2612380@nnrp2.proxad.net>
X-Trace: fu-berlin.de 943443714 1851345 195.88.151.190 (16 [6887])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


Eric DUCHET <eric.duchet@free.fr> schrieb:
>
> What happens with my ITEM table ?
> Why does it take so long time for deleting ?
> How can i improve my delete ?

Two possibilities:

First: drop your indexes, then delete your table and at last create the
indexes again.
Second: use truncate

HTH, Kathinka