arprilia Posted August 29, 2007 Share Posted August 29, 2007 Greetings to all.... I've encountered some problems with my query.... Although it's executed successfully, it takes a lot of time... the query:- SELECT pm_ic, pm_nama FROM a LEFT JOIN b ON (a.pm_id,a.iklan_id) = (b.pm_id,b.iklan_id) WHERE b.statusmohon_id = '98' AND b.iklandetail_id = '15' ORDER BY a.pm_nama BUT, when i remove the ORDER BY statement, it executes faster... Before this i used this query:- SELECT pm_ic,pm_nama FROM a,b WHERE a.pm_id=b.pm_id AND a.iklan_id=b.iklan_id AND b.statusmohon_id='98' AND b.iklandetail_id='15' ORDER BY pm_nama Any suggestions? Thanx in advance.... Link to comment https://forums.phpfreaks.com/topic/67189-join-order/ Share on other sites More sharing options...
fenway Posted August 29, 2007 Share Posted August 29, 2007 Ordering will always take more time, especially if there's no index to use... Link to comment https://forums.phpfreaks.com/topic/67189-join-order/#findComment-337255 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.