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.... Quote 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... Quote Link to comment https://forums.phpfreaks.com/topic/67189-join-order/#findComment-337255 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.