Re: Extremely slow deletes from table

From: Michael Milom <smilom@bellsouth.net> > >Even specifying the key directly, as in > > delete from pkgs where pk_pkg_id = 3685665001;> >results in very long delete times, sometimes in the order of 2-3 >minutes. Insertions are virtually instantaneous, and there are no >perceptible problems with selects. bcheck (many, many times) has turned >up absolutely nothing. The data appears to be consistent. Drop the index and recreate it. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com