5 posts about Covering Indexes by 5 contributors.
Know Covering Indexes? Share what you know with developers who are learning it.
Learn how PostgreSQL index-only scans use covering indexes and visibility maps, why heap fetches still occur, and how to verify scan behavior with EXPLAIN ANALYZE.
Learn SQL Server stored procedure performance practices, including selective queries, naming conventions, EXISTS checks, short transactions, error handling, SET NOCOUNT ON, and indexing.
Hello Learners. I hope you all are doing great. This article describes the Covering Indexes and Filtered Indexes. I would like to tell you that these type of Indexes can only be created as NONCLUSTERED.
In this article we will try to understand what a covering index is, how to avoid the expensive key lookup operations, and how it can improve our T-SQL performance multi fold times.
Learn how PostgreSQL index-only scans use covering indexes and the visibility map, and how to diagnose heap fetches with EXPLAIN ANALYZE.
DevSocialUpcoming · 3rd editionAI Agents ConferenceNov 23–27, 2026Live onlineMembers only16days leftRegisterPublish an article in this category and earn +1,000 SHARP when it is approved.
Write an article