db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Skip scan on a B-tree

The index is on (a, b) but the query tests only b. a has 10 values, so the index can jump from value to value.

task

Write the lookup of b = 5000 so that the planner uses the index.

hints