Re: [GENERAL] Query time is too long for netscape - Mailing list pgsql-general

From Mark Jewiss
Subject Re: [GENERAL] Query time is too long for netscape
Date
Msg-id Pine.BSO.4.10.10001250840260.25942-100000@office.knowledge.com
Whole thread Raw
In response to Query time is too long for netscape  (Chairudin Sentosa Harjo <chai@prima.net.id>)
List pgsql-general
Hello,

On Tue, 25 Jan 2000, Chairudin Sentosa Harjo wrote:

> The query looks like this:
> select a.custnum, b.fullname, b.address, a.usages from
> Detail a, Customer b
> where a.custnum=b.custnum;

Have you got any keys setup on these tables? That would help the query a
lot.

Mail out your table definitions (and the script) and then we can have a
look.

Regards,

Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com




pgsql-general by date:

Previous
From: "Vince DiCiero"
Date:
Subject: RE: [GENERAL] Re: pgsql-general-digest V1 #614
Next
From: Chairudin Sentosa Harjo
Date:
Subject: Re: [GENERAL] Query time is too long for netscape