"Silas Justiniano" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
