NoSQL
Document or Relational: Read-Time or Write-Time Cost
Relational modeling describes the entities and lets queries follow. Document modeling inverts that, and the inversion is the whole trade.
· 4 min
tag
#schema-design
Articles tagged “schema-design” on SQLPress — 3 in total.
3 articles
SQL Fundamentals
Composite Indexes: One Ordering, Not Three
Column order decides which queries a composite index can serve. The rule follows from the structure, and so do the cases where it does not hold.
· 3 min
MySQL
Why the Primary Key Is in Every Secondary Index
InnoDB stores the table inside its primary key. Almost every MySQL indexing consequence, good and bad, follows from that single decision.
· 3 min