MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: SHOW CREATE TABLEs
Posted by: Jaap Vermeer
Date: November 18, 2012 05:11PM

Thanks Rick.

Yes the field names are horrible.

I didn't create the tables, i just have to use them :(
The table VCG2LU has 22 million rows which is why everything is so slow.

But it is already getting better, thanks to your tips.

Thanks Rick.

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


Subject
Views
Written By
Posted
6-table join, good indices, bad perf
2607
Jaap Vermeer
November 16, 2012 11:32AM
Re: 6-table join, good indices, bad perf
1491
Rick James
November 17, 2012 10:41AM
SHOW CREATE TABLEs
2802
Jaap Vermeer
November 17, 2012 11:36AM
Re: SHOW CREATE TABLEs
1253
Rick James
November 18, 2012 03:37PM
Re: SHOW CREATE TABLEs
1017
Jaap Vermeer
November 18, 2012 05:11PM
Re: 6-table join, good indices, bad perf
1137
Øystein Grøvlen
November 19, 2012 07:22AM


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.