[PERFORM] redundent index?

2003-10-29 Thread Robert Treat
I just noticed on one of my tables I have the following two indexes: Indexes: entity_watch_map_pkey primary key btree (entity_id, watch_id), ewm_entity_id btree (entity_id), I can't think of why the second index is there, as ISTM there is no instance where the first index wouldn't be

Re: [PERFORM] redundent index?

2003-10-29 Thread Rod Taylor
On Wed, 2003-10-29 at 09:03, Robert Treat wrote: I just noticed on one of my tables I have the following two indexes: Indexes: entity_watch_map_pkey primary key btree (entity_id, watch_id), ewm_entity_id btree (entity_id), I can't think of why the second index is there, as ISTM