MySQL Forums
Forum List  »  MySQL Query Browser

Re: Help me to get fast query
Posted by: kordirko kordirko
Date: January 09, 2012 05:46PM


Please run this command:
    show index from transaction_xtras
and verify if an index on column 'transaction_id' exists.
If no, then create the index on this column and check how your query performs after this change.

Edited 3 time(s). Last edit at 01/09/2012 05:54PM by kordirko kordirko.

Options: ReplyQuote

Written By
January 08, 2012 12:59AM
January 08, 2012 12:21PM
January 08, 2012 12:28PM
January 08, 2012 08:25PM
Re: Help me to get fast query
January 09, 2012 05:46PM
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.