I know understand. Thank you ;) On 2/2/06, Richard Huxton <dev@xxxxxxxxxxxx> wrote: > Silas Justiniano wrote: > > Sorry, I'll remake (rewrite? redo? ... bad English :/ ) my question: > > > > I have Books, Authors and Intermediate table. At intermediate I'm > > currently using the following indexes: > > > > CREATE INDEX authorIndex ON Intermediate(author_id); > > CREATE INDEX bookIndex ON Intermediate(book_id); > > > > I need a third index to not allow duplicated data in my table: > > > > CREATE UNIQUE INDEX blablabla ON Intermediate(author_id, book_id); > > > > I'd like to know if, using the third index I can delete one of the > > first. Maybe both? > > You can probably delete authorIndex without impacting performance too much. > > -- > Richard Huxton > Archonet Ltd > -- Silas Justiniano - Brazil
