This is a continuation of my posts on relational databases, started here. Previous posts on this theme, “Data Modeling“, “Let’s Talk About Database Schema“, “The Exasperating Topic of Database Indexes“, “The Keys & Relationships of Relational Databases“, and “Relational Database Query Optimization“. Consider you’re a die-hard fan of progressive death metal, with a particular affinity... Continue reading →

We’re discussing query optimization techniques for relational databases, covering both common and uncommon strategies across various database management systems. These techniques range from basic practices like indexing to advanced methods like bitmap indexing and adaptive cursor sharing. Continue reading →

Together, keys and relationships not only maintain data accuracy and consistency but also support meaningful and logical data retrieval and insights. Continue reading →

The article delves into the intricacies of indexing in various relational databases: SQL Server, Oracle, MariaDB/MySQL, and PostgreSQL. Each database system’s section elucidates the creation and purpose of different index types, from primary and unique indexes to specialized ones like full-text and spatial indexes. The discussion culminates in a poignant analogy, likening database indexes to... Continue reading →