What is the role of indexes in an SQL database and how do they affect query performance?

SQL database indexes are data structures that speed up data retrieval. They act as pointers to table rows, improving query performance, enforcing uniqueness, and aiding query optimizer. An example of creating an index in SQL is provided.