How to Choose Column Order in a MySQL Composite Index
When a MySQL query filters on several columns, the order of those columns in an index determines how MySQL can use it. A composite…
Read postCategory archive
Databases
Posts filed under Databases, newest first.
4 published posts
All blog posts
All Databases posts
Everything in this archive, newest first.
How Cursor Pagination Works and When to Use It Instead of Offset Pagination
For a database-backed API that splits a large list into pages, the pagination method affects query cost and which records users see as the…
Read postHow to Read PostgreSQL EXPLAIN ANALYZE Output
When a PostgreSQL query runs slowly, EXPLAIN ANALYZE shows how PostgreSQL planned and executed it. The output is a tree of operations, such as…
Read postHow to Create a PostgreSQL Index Without Blocking Writes
On a PostgreSQL table serving a live web application, a regular index build can cause an outage because it holds a lock while PostgreSQL…
Read post