Distributed Loose Index Scan (aka Skip/Jump/Hybrid Scan). An example with time series in YugabyteDB

Do you think using the PostgreSQL code for YugabyteDB’s query layer constrains the optimization of distributed SQL processing? Not at all, but this is a common misunderstanding of YugabyteDB’s innovative architecture spread by competitors. Let’s clear this up once and for all with a simple example. YugabyteDB can scan multiple ranges in one Index Scan. This feature, known as Loose Index Scan or Index Skip Scan, doesn’t exist in PostgreSQL or in other Distributed SQL databases. Only YugabyteDB, the PostgreSQL-compatible Distributed SQL database, provides it. We’ll examine examples where these results in substantial performance boosts and verifies that YugabyteDB implements numerous optimization enhancements beyond PostgreSQL