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

Поиск
Список
Период
Сортировка
От Mark Jewiss
Тема Re: [GENERAL] Query time is too long for netscape
Дата
Msg-id Pine.BSO.4.10.10001250840260.25942-100000@office.knowledge.com
обсуждение исходный текст
Ответ на Query time is too long for netscape  (Chairudin Sentosa Harjo <chai@prima.net.id>)
Список 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 по дате отправления:

Предыдущее
От: "Vince DiCiero"
Дата:
Сообщение: RE: [GENERAL] Re: pgsql-general-digest V1 #614
Следующее
От: Chairudin Sentosa Harjo
Дата:
Сообщение: Re: [GENERAL] Query time is too long for netscape