MySQL Forums
Forum List  »  Performance

Re: query speed issue
Posted by: Jørgen Løland
Date: August 05, 2011 01:02AM

Hi Sajid,

Please provide the output of EXPLAIN for the query (and enclose the output in [ code] [/ code] tags)


For future reference, here's the query in a more readable format:

SELECT tbltransactionac.eDate AS eDate, tbltransactionac.DocNo AS DocNo,
       tbltransactionac.Type AS Type, tbltransactionac.PayDesc AS PayDesc,
       ifnull(tbltransactionac.Debit,0) AS Debit, 
       ifnull(tbltransactionac.Credit,0) AS Credit, tblaccounts.ID AS ID, 
       tblaccounts.AcTitle AS AcTitle, tblaccounts.Type AS accType,
       tblaccounts.Address AS Address, tblaccounts.City AS City,
       tbltransactionac.ID AS tid 
FROM (tblaccounts JOIN tbltransactionac 
                 ((ON tblaccounts.ID = tbltransactionac.AccID))) 
ORDER BY tbltransactionac.eDate;

Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
1510
August 03, 2011 10:17AM
Re: query speed issue
643
August 05, 2011 01:02AM
844
August 10, 2011 07:38PM


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.