Search Postgresql Archives

Indexes again

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



  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?

  Thank you! Bye!


--
Silas Justiniano - Brazil


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux