Re: Would this take long than 10-15 seconds to complete?

[Øystein Grøvlen]

Hi,

The EXPLAIN tells me that it will do a full index scan of table c with 142253 rows.

Your question confuses me, as you ask about an update statement, but the EXPLAIN is, AFAICT, from a SELECT statement, (select_type=SIMPLE, not UPDATE).

How long it will take will depend on a lot of factors. E.g., whether data is already cached in memory.

If you want to get more advice, you need to show the actual statement.

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway