Why is MySQL Delete on Foreign Key Index locking a record not part of the index (leads to DEADLOCK) - Database Administrators Stack Exchange
What are advantages and disadvantages of indexes in MySQL?
MySQL InnoDB: Primary Key always included in secondary indexes as the right-most columns… or not – lefred blog: tribulations of a MySQL Evangelist
An in-depth look at Database Indexing | by Kousik Nath | We've moved to freeCodeCamp.org/news | Medium
MySQL Primary Key: CREATE and ALTER TABLE Statements - Devart Blog
How To Use Indexes in MySQL | DigitalOcean
MySQL Primary Key: CREATE and ALTER TABLE Statements - Devart Blog
MySQL InnoDB: Primary Key always included in secondary indexes as the right-most columns… or not – lefred blog: tribulations of a MySQL Evangelist
Why isn't MySQL using my index?
MySQL Primary Key
MySQL: Composite Primary Key, Unique and simple indexes for relational table - Stack Overflow
What is a composite primary key, and how to create one in phpMyAdmin
Create Index - SQLyog Knowledge Base
How to Optimize Query Performance in MySQL Databases - CoderPad
Optimizing MySQL Composite Index in InnoDB - Alibaba Cloud Community
database design - MySQL is there a point to having a primary key on a lookup table which referrers to a primary key on another table which is indexed? - Stack Overflow
MySQL CREATE INDEX
The primary key is the default clustered index in SQL Server and MySQL. This implies a 'clustered index penalty' on all non-clustered indexes.
SQL index overview and strategy
Working with Indexes in MySQL | 365 Data Science
