Re: Indexes

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