On Jan 18, 2006, at 4:53 , Silas Justiniano wrote:
CREATE UNIQUE INDEX foo ON Intermediate(book_id, author_id);
You'll want this index for normalization.
CREATE UNIQUE INDEX bar ON Intermediate(book_id); CREATE UNIQUE INDEX baz ON Intermediate(author_id);
You probably don't want these two indexes unless you want to have only one entry for each book, or one entry for each author. Many books have multiple authors and many authors write more than one book, so you probably don't want to restrict this.
Michael Glaesemann grzm myrealbox com
