From: | Silas Justiniano <silasju(at)gmail(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Indexes again |
Date: | 2006-02-02 13:21:42 |
Message-ID: | 58e3b9040602020521t607c5820mc70eb5f9025d582f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I know understand. Thank you ;)
On 2/2/06, Richard Huxton <dev(at)archonet(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2006-02-02 13:32:49 | Re: plpgsql parameters |
Previous Message | FERREIRA, William (VALTECH) | 2006-02-02 13:15:58 | plpgsql parameters |