In 250 words or more, answer the following. Retrieval of

In 250 words or more, answer the following.

Retrieval of data in SQL can be sped up by the creation of indexes in a table. Explain what an index is and how it works in speeding up data retrieval. Describe one issue that can occur by using too many indexes in a table.