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 as
 select
  c.name,
  c.ext,
  c.uid,
  tmail.description as mail,
  tcontext.description as context,
  tserver.description as server,
  admins.name as admin,
  c.id
 from
  customers c,
  codes tmail,
  codes tserver,
  codes tcontext,
  admins
 where
  c.fkadmin=admins.id
  and c.fkmailcode = tmail.id
  and c.fkcontext = tcontext.id
  and c.fkserver = tserver.id;




Tue, 16 Nov 1999 18:44:19 -0500
Tyson Oswald <tysono@iserv.net>
Slow access