previous | top | next

Speeding things up


create table reservations (
      flight_number    integer,
      departure_time   datetime,
      passenger_name   string
);

create index on reservations by date, flight_number;
create index on reservations by passenger_name;


philg@mit.edu