Re: Indexes

[Michael Glaesemann <grzm(at)myrealbox(dot)com>]

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