dbaplus Community

Nov 18, 2022 · Databases

Why openGauss Misses Index‑Only Scan and How USTORE Fixes It

The article examines why openGauss 2.0/3.0 cannot use Index‑Only Scan for covering indexes, explores the role of the visibility map and VACUUM, compares behavior with PostgreSQL 11, and shows how the USTORE storage engine can finally enable true covering indexes.