MySQL Forums
Forum List  »  Views

Re: SELECT from view crashes
Posted by: Daniele Donati
Date: May 19, 2015 02:21AM

Hi Peter,
I really really appreciate your suggestions.

EXPLAIN SELECT has shown a serious problem on a table structure: a lack of an INDEX on the last added field which caused the use of the extra "using join buffer" on 8 joined tables!!! ... causing the problem.

Really many thanks again.
Best regards

Options: ReplyQuote


Subject
Views
Written By
Posted
4180
May 18, 2015 04:18PM
1388
May 18, 2015 09:42PM
Re: SELECT from view crashes
1302
May 19, 2015 02:21AM
1307
May 19, 2015 11:27AM
1192
May 19, 2015 02:33AM


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.