MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Confusion on SELECT query
Posted by: Phillip Ward
Date: May 27, 2014 05:48AM

If you haven't already, add an index on parent_device.

Without it, your query will slow down (dramatically) as your data grows in size.

Regards, Phill W.

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


Subject
Written By
Posted
Confusion on SELECT query
Leo Edwards
May 23, 2014 07:35AM
Re: Confusion on SELECT query
Barry Galbraith
May 24, 2014 03:34AM
Re: Confusion on SELECT query
Leo Edwards
May 27, 2014 02:32AM
Re: Confusion on SELECT query
Phillip Ward
May 27, 2014 05:48AM


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.