[GENERAL] implicit index created, do I need to also create an explicit index?

[Mark Harrison]

So I create a table with unique fields, and it creates an implicit index.

1.  This is a general purpose index, correct?  I.e. not used solely for
    ensuring uniqueness, so I don't need to create another index on
    the same field explicitly, right?

2.  What are the implications of creating another index, such as
     create index foo on tv_workspace(name)?  Is is just a duplicate
    of the implicitly created index?


create table tv_workspace (
    name varchar(32) unique not null,
    p4client varchar(64) unique not null,
    owner bigint not null
);
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "tv_workspace_name_key" for 
table "tv_workspace"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "tv_workspace_p4client_key" for 
table "tv_workspace"


TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly