Search

Lessons (5)

• Database Relations & Foreign Keys

  … foreign keys connect one-to-one, one-to-many and many-to-many records](/img/database/relations.svg …

• DBMS Foundations, Keys & Normalization

  … by engine. Foreign key References another table key and protects integrity. Do not claim unique keys allow exactly …

• Indexes, EXPLAIN & Query Plans

  … a matching expression index. - Forgetting the join-side foreign key index. - Adding an index without measuring the actual …

• Database Indexing & Transactions

  … Check pg stat user indexes and remove them. Index these: primary keys (automatic), foreign keys, columns in frequent …

• Normalization & Denormalization

  … Then I remove non-key-to-non-key dependencies for 3NF, using foreign keys and unique constraints to …