By creating indexes on columns by which you often search a table, you can
reduce the number of rows that
There are some trade-offs in using indexes: indexes speed up searches but slow down inserts and updates. As a general rule, every table should have at least a primary key constraint.
See