#sql - Danny's blog

Skip to main content

Hashnode Danny's blog

Command Palette

Search for a command to run...

#sql

Articles tagged with #sql

Foreign Key with missing indexes
Relational databases have references to other tables via 1-Many relationships using a foreign key. CREATE TABLE Bar( id int NOT NULL, name varchar(128), PRIMARY KEY (id) ); CREATE TABLE Foo ( id int NOT NULL,...
Dec 24, 20242 min read11
`LIKE` uses a range index
A Django's Auth table's indexes: mysql> show index from auth_user; +-----------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_un...
May 21, 20243 min read20

© 2026 Danny's blog

Archive
Recommendations
Privacy
Terms