A Close Look at the Index INCLUDE Clause — The INCLUDE clause for CREATE INDEX is available in SQL Server, IBM Db2, and, most recently, PostgreSQL. It allows you to include extra columns’ data to be referred to in index-only scans withou being key columns of the index itself. Markus explains.
Appears in lists (1)
More like this (3)
5. An Overview of Postgres's JSON Capabilities — Postgres's JSON capabilities have continued to improve over the...
Combined Indexes vs. Separate Indexes — A common question when it comes to designing relational databases...
Don’t Forget the Benefits of BRIN Indexes — BRIN indexes (which provide an efficient way to...