acidglitter Posted August 13, 2008 Share Posted August 13, 2008 just to make sure.. fields that are used in the WHERE clause should have an index on them. but every time? even if only one query on the entire site searches for that field in the where clause? or only if that field is searched for a lot? Link to comment https://forums.phpfreaks.com/topic/119562-tiny-indexing-question/ Share on other sites More sharing options...
Johntron Posted August 13, 2008 Share Posted August 13, 2008 only if that field is searched for a lot Link to comment https://forums.phpfreaks.com/topic/119562-tiny-indexing-question/#findComment-616035 Share on other sites More sharing options...
fenway Posted August 14, 2008 Share Posted August 14, 2008 just to make sure.. fields that are used in the WHERE clause should have an index on them. but every time? even if only one query on the entire site searches for that field in the where clause? or only if that field is searched for a lot? Not all fields, and not all separate indexes.... but yes, sometimes for a certain query, it has to be optimized "separately". Link to comment https://forums.phpfreaks.com/topic/119562-tiny-indexing-question/#findComment-616097 Share on other sites More sharing options...
corbin Posted August 14, 2008 Share Posted August 14, 2008 Full table scans are the devil. Link to comment https://forums.phpfreaks.com/topic/119562-tiny-indexing-question/#findComment-616192 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.