On Fri, Jul 9, 2010 at 7:30 AM, Neil Tompkins <neil.tompk...@googlemail.com>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
