MySQL Forums
Forum List  »  Performance

Re: Would this take long than 10-15 seconds to complete?
Posted by: Øystein Grøvlen
Date: May 31, 2018 03:23AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Would this take long than 10-15 seconds to complete?
88
May 31, 2018 03:23AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.