Re: query optimisation

Поиск
Список
Период
Сортировка
От shreedhar
Тема Re: query optimisation
Дата
Msg-id 011601c2eb7a$55dc3eb0$1201a8c0@a4005
обсуждение исходный текст
Ответ на query optimisation  (Abdul-wahid Paterson <aw@lintrix.net>)
Ответы Re: query optimisation
Список pgsql-general
1. Have you checked whether all fields which you are joining are indexed.

2. Are you sure that your query is not have any subselects, if it have any
subselects convert into joins.

3.Check what is the size of tables. If tables size is very big do filter
condtions

4. Even if you feel that your query is still working slow, then denormalise
your database and avoid atleast some joins.

Regards,
Sreedhar

----- Original Message -----
From: "Abdul-wahid Paterson" <aw@lintrix.net>
To: <pgsql-general@postgresql.org>
Sent: Saturday, March 15, 2003 6:39 AM
Subject: [GENERAL] query optimisation




В списке pgsql-general по дате отправления: