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. 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
Archived
This topic is now archived and is closed to further replies.