# SQLPress

> In-depth articles on PostgreSQL, MySQL, SQL Server, Oracle and modern data engineering — written for developers, analysts and database administrators.

Audience: software developers, data analysts and database administrators.
Language: English. Content license: © 2026 SQLPress, all rights reserved.
Full text of every article: https://sqlpress.com/llms-full.txt
Last updated: 2026-08-23

## Articles

- [Why an Index Is Not Used: the Estimate, Not the Index](https://sqlpress.com/blog/index-not-used-estimate-not-index.md): An index the planner ignores is usually a row-estimate problem. The fix starts with what the optimizer expected, not with the index definition. (category: PostgreSQL; tags: query-optimization, indexing, execution-plans, statistics; published: 2026-08-23; 3 min read; tested on PostgreSQL 18; workload: illustrative; html: https://sqlpress.com/blog/index-not-used-estimate-not-index/)

## Categories

- [PostgreSQL](https://sqlpress.com/categories/postgresql/): Query planning, indexing, extensions, replication and day-to-day operations on PostgreSQL.
- [MySQL](https://sqlpress.com/categories/mysql/): InnoDB internals, locking, replication topologies and performance tuning for MySQL and MariaDB.
- [SQL Server](https://sqlpress.com/categories/sql-server/): Execution plans, columnstore, Always On and T-SQL patterns for Microsoft SQL Server.
- [Oracle](https://sqlpress.com/categories/oracle/): Optimizer behavior, AWR analysis, partitioning and PL/SQL for Oracle Database.
- [SQLite](https://sqlpress.com/categories/sqlite/): Embedded database design, WAL mode, and using SQLite far beyond the toy examples.
- [NoSQL](https://sqlpress.com/categories/nosql/): Document, key-value, wide-column and graph stores — and when they beat a relational engine.
- [Data Engineering](https://sqlpress.com/categories/data-engineering/): Pipelines, warehouses, modeling, CDC and the analytics stack that sits on top of your database.
- [SQL Fundamentals](https://sqlpress.com/categories/sql-fundamentals/): The language itself: set theory, joins, window functions, CTEs and the mental models behind them.
- [Career](https://sqlpress.com/categories/career/): Interviews, on-call, incident reviews and growing as a database-focused engineer.

## Tags

- [execution-plans](https://sqlpress.com/tags/execution-plans/): 1 article(s)
- [indexing](https://sqlpress.com/tags/indexing/): 1 article(s)
- [query-optimization](https://sqlpress.com/tags/query-optimization/): 1 article(s)
- [statistics](https://sqlpress.com/tags/statistics/): 1 article(s)

## Feeds

- [RSS](https://sqlpress.com/rss.xml)
- [JSON Feed](https://sqlpress.com/feed.json)
- [Sitemap](https://sqlpress.com/sitemap-index.xml)