db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Extended statistics

Columns of one row are often correlated, but single-column statistics cannot say so. skew(a, b) has b = a: WHERE a = 1 AND b = 1 is estimated at about 10 rows and returns 1000.

task

Create dependency statistics so the estimate for WHERE a = 1 AND b = 1 is between 500 and 2000.

hints