medium10 pts · first answer countsindexingdata-modelling
Deleting a customer takes seconds
DELETE FROM customers WHERE id = 42 takes several seconds. orders.customer_id references customers(id) and has no index. Why is it slow?
Discussion 0
Join free to post in the discussion.
Related questions
- Purpose of a primary keyDatabase Administrator
- Third normal formDatabase Administrator
- When a B-tree index helpsDatabase Administrator
- What a foreign key enforcesDatabase Administrator
- Data type for moneyDatabase Administrator
- Gaps in auto-increment IDsDatabase Administrator
- Storing event timesDatabase Administrator
- Rejecting bad valuesDatabase Administrator