Articles by Tag #indexes
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Hotel Booking: Schema Design Comparison
1. Introduction Hotel booking systems face a fundamental design decision: how to model...
pg-index-health – a static analysis tool for your PostgreSQL database
Hello there! Since 2019, I have been developing an open-source tool called pg-index-health, which...
How to Postgres indexes review
Hey, in addition to Part 2, I recently started to review indexes in one of my prod databases. I would...
How Database Indexes Improve SQL Query Performance
SQL query performance can suffer as datasets grow. The solution? Database indexes. By organizing data...