"Silas Justiniano" <silasju@gmail.com> writes:
I normally create these two indexes:
CREATE UNIQUE INDEX foo ON Intermediate(book_id, author_id);
CREATE INDEX baz ON Intermediate(author_id);
Note that the second one isn't unique.
Or you can go the other way (<author_id,book_id> and <book_id>). The only
difference would be on queries like "WHERE author_id = ? and book_id BETWEEN ?
AND ?". If you never do range scans then it will hardly matter which way you
go. I tend to do it the way above just so it matches the column order in the
table.
--
greg
