Markus Winand • 4/30/2019

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

Read Original

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
Index INCLUDE Clause: How it works and when to use it

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
Quoting Thariq Shihipar
Simon Willison • 2 votes
2
Top picks — 2026 January
Paweł Grzybek • 1 votes
3
In Praise of –dry-run
Henrik Warne • 1 votes
4
Deep Learning is Powerful Because It Makes Hard Things Easy - Reflections 10 Years On
Ferenc Huszár • 1 votes
5
Vibe coding your first iOS app
William Denniss • 1 votes
6
AGI, ASI, A*I – Do we have all we need to get there?
John D. Cook • 1 votes