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? Quote Link to comment 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 Quote Link to comment 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". Quote Link to comment Share on other sites More sharing options...
corbin Posted August 14, 2008 Share Posted August 14, 2008 Full table scans are the devil. Quote Link to comment 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.