Topic
SQL ServerBeginnerThe single most important physical design decision in SQL Server, explained from first principles — with the queries to prove it.
#indexing#performance#schema-design
MySQLIntermediateIn MySQL's InnoDB, the table is the primary key index. That single fact shapes insert speed, index size and how you should pick primary keys.
#indexing#internals#schema-design
MongoDBBeginnerThe core modeling decision in MongoDB, with simple rules of thumb for one-to-few, one-to-many and many-to-many relationships.
#data-modeling#nosql#schema-design
Apache CassandraIntermediateForget normalization. In Cassandra you model one table per query, choose partition keys carefully and keep partitions bounded.
#data-modeling#nosql#schema-design
