What are indexes and why are they important?

• Indexes are data structures that speed up the retrieval of data from a database.

They work like the index in a book, allowing quick lookup of data without having to

scan the entire table.

Importance:

• Faster Searches: Improves query performance, especially for large datasets.
• Efficient Sorting: Helps in sorting and filtering operations.
• Primary and Foreign Keys: Automatically indexed to ensure quick data

retrieval.