Slow access

Hello,   Not sure is this is the place for this but,   I have two object
created a table (customers) and a view cust which joins customers and
cust runs pretty slow when select count(*) from cust.  I think it may be
an index issue, can anyone help?  there are about 1200 records in
customers and it takes about 30 seconds to count(*).  Also how to I
create a foreign key constraint?

Tyson Oswald

Create table Customers       (       id              serial,       Name            varchar(25),       UID
varchar(7),      Ext             char(4),       fkMailcode      int4,       fkContext       int4,       fkServer
int4,      fkAdmin         int4       );
 

drop index idx_Customers_fkAdmin;
drop index idx_Customers_fkMailcode;
drop index idx_Customers_fkServer;
drop index idx_Customers_fkContext;

Create index idx_Customers_fkAdmin on Customers(fkadmin);
Create index idx_Customers_fkMailcode on Customers(fkMailcode);
Create index idx_Customers_fkContext on Customers(fkContext);
Create index idx_Customers_fkServer on Customers(fkServer);

Create table Codes(id serial,description varchar(50),type varchar(5),typecode varchar(5));
create view cust asselect c.name, c.ext, c.uid, tmail.description as mail, tcontext.description as context,
tserver.descriptionas server, admins.name as admin, c.idfrom customers c, codes tmail, codes tserver, codes tcontext,
adminswherec.fkadmin=admins.id and c.fkmailcode = tmail.id and c.fkcontext = tcontext.id and c.fkserver = tserver.id;