Re: Delete rows faster ?

Dean,

This is very generic question you might want to rephrase it, make it more concrete. Any operation has its impact on the overall system performance. And subsequently your original question in most cases equivalent to asking "how do I make my system faster?".

I suggest starting with tracking down the corresponding bottleneck/culprit and try to remove/fix it. It could be anything starting from hardware I/O capacity to inappropriate statistics if delete contains sub query and it's the query that is slow.

• Vlad

On 11/14/06, Dean Paul <oracledbam_at_hotmail.com> wrote:
>
> Hi,
> How to make delete rows faster ?
> thanks
>
> _________________________________________________________________
> Stay in touch with old friends and meet new ones with Windows Live Spaces
>
> http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l