Re: "Delete From <table>" taking all day
From: Bob Leonard <farsider_at_postoffice.ptd.net>
Date: 1996/08/22
Message-ID: <321bbf05.0_at_downed.ptd.net>#1/1
Date: 1996/08/22
Message-ID: <321bbf05.0_at_downed.ptd.net>#1/1
Do you have any tables with foreign keys to this table, if so are the columns on the other tables indexed ?
Bob
In article <4vcbp9$6a3_at_lal.interserv.com>, meskillw_at_ncr.disa.mil says...
>
>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.
>
Received on Thu Aug 22 1996 - 00:00:00 CEST