MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: SQL syntax appears correct but EXPLAIN does not work?
Posted by: David Wynter
Date: July 18, 2005 10:54AM

I split the UPDATE into 3 UPDATES, total runtime for all three in series was 10 seconds! what a difference when the idexes can be used.

David

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
SQL syntax appears correct but EXPLAIN does not work?
4669
David Wynter
July 10, 2005 09:25AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2269
Russell Dyer
July 10, 2005 11:55AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2518
David Wynter
July 18, 2005 08:17AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2534
Jay Pipes
July 18, 2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2213
Jay Pipes
July 18, 2005 09:04AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2389
David Wynter
July 18, 2005 09:57AM
Re: SQL syntax appears correct but EXPLAIN does not work?
2243
David Wynter
July 18, 2005 10:54AM


Sorry, you can't reply to this topic. It has been closed.

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.