Re: "Delete From <table>" taking all day
From: Jochen Guther <guther_at_privat.prodata.de>
Date: 1996/08/24
Message-ID: <4vnork$ko6_at_sulu.prodata.de>#1/1
Date: 1996/08/24
Message-ID: <4vnork$ko6_at_sulu.prodata.de>#1/1
meskillw_at_ncr.disa.mil (Bill Meskill) wrote:
>Hi,
>I have a 4000 row table that's taking quite a long
>time to delete. What's going on?
>Bill Meskill
>FYI. I have my data and indexes separated on lots of
>different disks and have allocated 80M for the
>SGA (a full database export is 10M). There are only
>2 people on the server.
Have you tried "truncate table" ? Received on Sat Aug 24 1996 - 00:00:00 CEST