RDB optmization
SQL Tuning: Generating Optimal Execution Plans
amazon.com
Techniques for optimizing SQL queries in a high-traffic application
link: https://readmedium.com/en/techniques-for-optimizing-sql-queries-in-a-high-traffic-application-6663e3f10e23
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
use-the-index-luke.com
SQL Performance Explained Everything Developers Need to Know about SQL Performance
amazon.com
It turns out that the only thing developers need to learn is how to index. Database indexing is, in fact, a development task. That is because the most important information for proper indexing is not the storage system configuration or the hardware setup. The most important information for indexing is how the application queries the data.
Markus Winand • Who has to add the right indexes to an SQL database?
as developers, we know how the app is accesing the data → the access path
Learning SQL: Generate, Manipulate, and Retrieve Data
amazon.com
SQL Cookbook: Query Solutions and Techniques for All SQL Users
amazon.com
How to Optimize Indexing for Distributed One-to-Many Join With Pagination
dev.to
How to Optimize Indexing for Distributed One-to-Many Join With Pagination
Many developers have years of SQL experience yet they know very little about the processing that happens in the database.