MySQL Forums
Forum List  »  Performance

Re: high cpu on request with JOIN
Posted by: Øystein Grøvlen
Date: January 15, 2016 05:43AM

Hi,

In order to be able to give good advice on improving query performance, we need to know more about the tables involved. (The output of SHOW CREATE TABLE for both tables would be useful.) However, assuming that iViewConferenceId is a column of the meeting table, I would guess what is needed is to create an index on this column.

Regards,

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

Options: ReplyQuote


Subject
Views
Written By
Posted
1357
January 15, 2016 03:49AM
Re: high cpu on request with JOIN
677
January 15, 2016 05:43AM


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.