MySQL Forums
Forum List  »  MySQL Query Browser

Re: Help me to get fast query
Posted by: kordirko kordirko
Date: January 08, 2012 09:20AM


it would be helpful if you showed us a structure of tables, indexes and an explain plan.
Just execute:
   show create table table_name
   show index from table_name
for each table name used in your query,
and also:
   explain your_query_goes_here
and post output of these commands.

Options: ReplyQuote

Written By
January 08, 2012 12:59AM
Re: Help me to get fast query
January 08, 2012 09:20AM
January 08, 2012 12:21PM
January 08, 2012 12:28PM
January 08, 2012 08:25PM
January 09, 2012 08:30PM

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.