Indexes are a common way to enhance database performance. An
index allows the database server to find and retrieve specific
rows much faster than it could do without an index. But indexes
also add overhead to the database system as a whole, so they
should be used sensibly.