ManiacDan Posted October 23, 2012 Share Posted October 23, 2012 Just FYI. Fields used in the ON clause of a JOIN matter as well. Since those are usually FOREIGN KEYS, they are usually indexed anyway; but it bears mentioning here. Very true as a general note, his queries didn't use joins so I didn't mention it. Foreign keys are sometimes indexed, but new users especially rarely know they even exist. Quote Link to comment https://forums.phpfreaks.com/topic/269782-query-takes-forever-to-run/page/2/#findComment-1387118 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.