Posted: Tue Jul 19, 2005 2:38 pm
Well you'll want to be a little more selective than that
Indices will slow down inserts/deletes/updates slightly, but speed up selects. This looks like its an application where data is being inserted more of less continuously (logging), while selects are more user driven and rare? If that's the case you'd be hurting "general preformance/throughput" in favor of a less common operation. "Tuning" a database is almost always about such tradeoffs.