database performance: Java Linux Databases: Indexes
Adding indexes to columns is easy, cheap and very beneficial.
The cost of updating the indexes did not seem to cause a noticeable impact on write performance and having indexes does provide large benefits when used.
Most databases performed well with or without having indexes added on all the columns in the table,
Postgresql suffered the most (taking a 50% hit with all the indexes) and strangely enough MySQL performed better with the indexes than without!
