CREATE INDEX ix_rating
  ON rating
  (media_id, media_type);