RDB optmization

RDB optmization

Franco Passeggi

SQL Tuning: Generating Optimal Execution Plans

Cover of SQL Tuning: Generating Optimal Execution Plans

Who has to add the right indexes to an SQL database?

Markus Winand use-the-index-luke.com

Thumbnail of Who has to add the right indexes to an SQL database?

SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...

use-the-index-luke.com

Thumbnail of SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...

Cost of a Join

brianlikespostgres.com

well placed indexes makes joining many huge tables easy

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

How to Optimize Indexing for Distributed One-to-Many Join With Pagination

Thumbnail of How to Optimize Indexing for Distributed One-to-Many Join With Pagination

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.

Markus Winand • Who has to add the right indexes to an SQL database?

Learning SQL: Generate, Manipulate, and Retrieve Data

Cover of Learning SQL: Generate, Manipulate, and Retrieve Data

SQL Performance Explained Everything Developers Need to Know about SQL Performance

Cover of SQL Performance Explained Everything Developers Need to Know about SQL Performance