Optimizing SQL queries
In this video, we use a practical example to explore the basics of SQL query optimization and its tools.
Friendly community:
https://t.me/pse_club
Developer resources:
https://proselyte.net/
Link to the GitHub repository with queries:
https://github.com/proselytear/sql_op...
00:00:00 Introduction
00:00:52 Creating a data structure
00:02:25 Running the first version of a query
00:04:30 EXPLAIN and EXPLAIN ANALYZE
00:08:22 First query optimization and performance analysis
00:11:12 Adding indexes
00:12:47 Non-SARGable EXTRACT function and performance comparison with the first query
00:15:39 Conclusion