Indexes used in databases can speed up searches for information, but if they are not carefully created, they can have a negative impact on database performance.

Research all of the following online, and discuss them in your posting:

• Identify the general purpose of indexing in a database.
• Identify the different types of indexes used and the related impact of each on the performance of a database system.
• What is the impact of creating indexes on foreign keys that are used in a relationship that enforces referential integrity?
• What is the impact of creating too many indexes on one table?

Be sure to support your information by citing at least 2 references using APA format.