Database Query Optimization: How to Improve Query Performance in SQL

I have an SQL database that stores a large amount of data, and I'm experiencing slow query performance when retrieving information. What are some strategies and best practices for optimizing database queries in SQL to achieve better performance?

Here's an example query I'm working with:

Code:

SELECT first_name, last_name, email
FROM users
WHERE registration_date >= '2023-01-01'
ORDER BY last_name ASC;

While this query works, it's becoming slow as the dataset grows. Could you provide guidance on optimizing this query and potentially using indexes or other techniques to speed up data retrieval? Additionally, are there any common pitfalls I should know when optimizing SQL queries?
Your insights, including code examples if applicable, would be greatly appreciated. Thank you!

 

Maybe CREATE an INDEX on registration_date and possibly on last_name?