Drill 15: Find the core line — Performance basics

create table lessons (
  id integer generated always as identity primary key,
  course_id integer not null,
  title text not null
);

explain analyze
select title
from lessons
where course_id = 7;

create index lessons_course_idx on lessons (course_id);

analyze lessons;

vacuum lessons;