Markus Winand • 4/30/2019

Index INCLUDE Clause: How it works and when to use it

This technical article provides a deep dive into the INCLUDE clause available in CREATE INDEX statements for databases like SQL Server, Db2, and PostgreSQL. It explains the clause's function by first recapping B-tree index mechanics and index-only scans, then detailing how INCLUDE columns optimize queries by storing non-key data in the leaf nodes to avoid table access, improving performance.

0 comments

#indexing #postgresql #Database Optimization