Re: [GENERAL] Query time is too long for netscape

From: Mark Jewiss <mark(at)knowledge(dot)com>
To: Chairudin Sentosa Harjo <chai(at)prima(dot)net(dot)id>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Query time is too long for netscape
Date: 2000-01-25 08:43:24
Message-ID: Pine.BSO.4.10.10001250840260.25942-100000@office.knowledge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chairudin Sentosa Harjo 2000-01-25 09:11:38 Re: [GENERAL] Query time is too long for netscape
Previous Message Vince DiCiero 2000-01-25 02:43:03 RE: [GENERAL] Re: pgsql-general-digest V1 #614