One wide index or multiple narrow indexes?

Or “If one index is good, surely many indexes (indexes? indices? indi?) will be better”This is a question that comes up very often on the forums. Something along the lines of:I have a query with multiple where clause conditions on a table. Should I create one index for each condition, or one index with all the columns in it? The question basically boils down to this: Which is more optimal and