Correct. To verify this, simply create a select with the same structure as
your delete - the execution plan will be similar.
I do not believe limit will help you, however, as it is only applied after
execution, when the full dataset is known.
On Thu, Sep 9, 2010 at 8:06 AM, Ananda Kumar wrote:
Vincent,
Since the column is indexed, it would use the index during the delete.
regards
anandkl
On Thu, Sep 9, 2010 at 5:47 AM, Daevid Vincent wrote:
> I am curious about something.
>
> I have a "glue" or "hanging" table like so:
>
> CREATE TABLE `fault_impact_has_fault_system_impact` (
> `id
I am curious about something.
I have a "glue" or "hanging" table like so:
CREATE TABLE `fault_impact_has_fault_system_impact` (
`id_fault_impact` int(10) unsigned NOT NULL,
`id_fault_system_impact` smallint(5) unsigned NOT NULL,
KEY `fault_impact_key` (`id_fault_impact`,`id_fault_system_imp