.com]
Sent: Thursday, March 18, 2010 11:15 AM
To: Price, Randall
Cc: Ian Simpson; Johan De Meersman; [MySQL]
Subject: Re: Question about DELETE
delete will also cause the undo(before image) to be generated, in case u want
to rollback. This will also add up to the delete completion time.
After each m
umber of deletes.
>
> So I am at a quandary as to how to make this delete process perform better.
>
> Thanks,
>
> -Randall Price
>
>
> -Original Message-
> From: Ian Simpson [mailto:i...@it.myjobgroup.co.uk]
> Sent: Thursday, March 18, 2010 10:11 AM
> To
: Thursday, March 18, 2010 10:11 AM
To: Price, Randall
Cc: Johan De Meersman; Ananda Kumar; [MySQL]
Subject: RE: Question about DELETE
Hi Randall,
If you're talking about processes that are taking that long, then
running SHOW PROCESSLIST several times during the operation should give
you a rough
he more records you delete,
> unless the indexing is happening multiple times?
>
> Thanks,
>
> -Randall Price
>
>
> From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
> Meersman
> Sent: Thursday, March 18, 2010 6:48 AM
> To: Ananda Kumar
>
] On Behalf Of Johan De
Meersman
Sent: Thursday, March 18, 2010 6:48 AM
To: Ananda Kumar
Cc: Price, Randall; [MySQL]
Subject: Re: Question about DELETE
Given that OP is talking about a single delete statement, I'm gonna be very
surprised if he manages to squeeze an intermediate commit in
Given that OP is talking about a single delete statement, I'm gonna be very
surprised if he manages to squeeze an intermediate commit in there :-)
For a single-statement delete on a single table, the indexes will be rebuilt
only once. I'm not entirely sure what happens to cascaded deletes, though.
Hi,
It depends how frequently ur doing a commit.
If you have written a plsql, with loop and if you commit after each row is
deleted, then it get update for each row. Else if you commit at the end the
loop, it commits only once for all the rows deleted.
regards
anandkl
On Thu, Mar 18, 2010 at 1:21
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> Does DELETE take advantage of index to locate more quickly row to be deleted ?
>
> Thank you :)
>
> Jocelyn Fournier
> Presence-PC
Of course.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL
