Nice tips. I'm interested in https://sqlfordevs.com/sorted-table-faster-range-scan Would you use this approach for something like:

1) movie_actors (movie_id, actor_id, order_index)

2) movie_watchlist (movie_id, user_id, created_at)

3) movie_ratings (movie_id, user_id, rating, created_at)

I know strange question, but most guides suggest all these table should have autoincrement id column