Question: Explain the purpose of indexing in a database.

Answer: Indexing is used to speed up the data retrieval process by creating a data structure that allows for faster lookup of rows based on specific columns.

Example:

Creating an index on the 'user_id' column to quickly locate user information in a large user table.