---
title: "Discussion on \"Foreign Key with missing indexes\" | Hashnode"
description: "Discussion on \"Foreign Key with missing indexes\". Relational databases have references to other tables via 1-Many relationships using a foreign key.\nCREATE TABLE Bar(\n    id          int NOT NULL,\n    name        varchar(128),\n    PRIMARY KEY (id)\n);\n\nCREATE TABLE Foo (\n    id          int NOT NULL,..."
url: "https://hashnode.com/posts/foreign-key-with-missing-indexes/676a1e36f93568d47bea9ceb"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Foreign Key with missing indexes](https://blog.danwald.me/foreign-key-with-missing-indexes?utm_source=hashnode&utm_medium=feed)

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, 2024 · 2 min read · blog.danwald.me  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#index](https://hashnode.com/tag/index)
-   [#foreign-key](https://hashnode.com/tag/foreign-key)
-   [#constraints](https://hashnode.com/tag/constraints)

## Written by

[Danny Crasto](https://hashnode.com/@danwald)

@danwald · dubai, uae

  
[View profile](https://hashnode.com/@danwald)

backend/cloud engineer | mentor | pythonista

I am developer/code-reviewer/debugger/bug-fixer/architect/teacher/builder from dubai, uae

## Responses

Markdown supported · ⌘↵ to post

No responses yet.