Indexes prevent duplicate entries in the column or combination of columns on which it is created. Since SQL indexes are primarily a performance tool, they are most useful when a database grows in size.