Re: Two queries are better than one?

Поиск
Список
Период
Сортировка
От Karim Nassar
Тема Re: Two queries are better than one?
Дата
Msg-id 1122610899.11862.63.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Two queries are better than one?  (Gnanavel S <s.gnanavel@gmail.com>)
Ответы Re: Two queries are better than one?  (Gnanavel S <s.gnanavel@gmail.com>)
Список pgsql-performance
On Fri, 2005-07-29 at 09:41 +0530, Gnanavel S wrote:

>
>         Joined:
>
>         test=> explain analyze
>         test->    SELECT cli_name,order.*
>         test->               FROM order
>         test->               JOIN client ON (ord_client = cli_code)
>         test->              WHERE ord_batch='343B' AND
>         ord_id='12-645';
>
> where is the cli_code condition in the above query?

I don't understand the question. ord_client is the client code, and
cli_code is the client code, for their respective tables. batch/id is
unique, so there is only one record from order, and only one client to
associate.

Clearer?

--
Karim Nassar <karim.nassar@acm.org>


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

Предыдущее
От: Gnanavel S
Дата:
Сообщение: Re: Two queries are better than one?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Left joining against two empty tables makes a query