[MDEV-20777] Foreign keys without indexes Created: 2019-10-08 Updated: 2023-08-11 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Federico Razzoli | Assignee: | Aleksey Midenkov |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | foreign-keys, snc | ||
| Issue Links: |
|
||||||||
| Description |
|
Some DBMSs, like Oracle, allow to create a foreign key without a matching index. The use case for this is when the child table is big or heavily written, and the parent table is rarely or never updated/deleted. |