I have a situtation where i need to improve the sql performance
My sql is
from EDetail A
ON A.MainID = B.StaffID
INNER JOIN People_Detail C
ON C.PID = A.MainID
EDetail has 100,000 rows
EMand has 6 million rows
People_Detail has 50000 rows,
Its taking for ever (> 20 minutes and still running) to execute the sql although i have indexes on A.MainID and B.StaffID.
Any ideas how i can improve the performance?
Any help would be really apprecaited