Explain
Posted by:
Alex Singh
Date: March 06, 2013 07:20AM
Following query is taking around 15 seconds
SELECT id, dt, lastchange, custom1 AS UID, custom2 AS Phone, beneficiary.name, fhname, habitation, village, block, district
FROM beneficiary
JOIN tickets ON uid = subject
WHERE owner =2
AND `status` = '3'
Where beneficary table has 60000 records and tickets table has 4000 records.
Can you please help to optimize
Subject
Views
Written By
Posted
Explain
1337
March 06, 2013 07:20AM
719
March 06, 2013 11:59AM
636
March 11, 2013 01: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.