Re: combined or single indexes?

[Johan De Meersman]

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