From: Johan De Meersman Date: July 9 2010 5:43am Subject: Re: combined or single indexes? List-Archive: http://lists.mysql.com/mysql/222129 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e644df0aeaaa53048aede168 --0016e644df0aeaaa53048aede168 Content-Type: text/plain; charset=ISO-8859-1 On Fri, Jul 9, 2010 at 7:30 AM, Neil Tompkins wrote: > > Should we be looking to create a index for all fields that we might be > perform a select condition in a where clause for ? It's a bit of trial and error, you have to weight the number of times you select based on a potential index vs. the impact that index might have for the amount of updates you do on the table. Generally speaking, though, it's indeed a good idea to find the most-frequently used where-clauses and index them. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0016e644df0aeaaa53048aede168--