Re:Probabilistic Many-to-Many Relationships (with Bloom Filt...
by nierman on Friday August 31, 2012 @03:08PM
(#4461201)
and you probably want to include these indices in any case to enforce that a given (user, movie) pair in the join table is unique (unless you want to track if a rating was changed and when, etc.)
further, you might decide to cluster on the index or partition.
(edit, oh, yeah, it's right there in the parent post....)