Re: [SQL] How could I improve a query with a function in the join clause?

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: [SQL] How could I improve a query with a function in the join clause?
Дата
Msg-id 57821318-D207-49C0-A499-9F2DE5745F9B@a-kretschmer.de
обсуждение исходный текст
Ответ на [SQL] How could I improve a query with a function in the join clause?  (Daniel Franco <dpinheirofranco@gmail.com>)
Список pgsql-sql
Дерево обсуждения 
On 14 September 2017 01:55:48 GMT+02:00, Daniel Franco <dpinheirofranco@gmail.com> wrote:
>I'm trying to improve the performance of a query in PostgreSQL with
>lots of
>left joins that uses the lower function in the join condition. The
>database
>version is 8.3.
>
>
>
>What is the best option for optimizing this type of query?
>
>Thanks in advance.


Upgrade to an actual Version.


Andreas


--
2ndQuadrant - The PostgreSQL Support Company


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

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

Предыдущее
От: Daniel Franco
Дата:
Сообщение: [SQL] How could I improve a query with a function in the join clause?
Следующее
От: srilinux
Дата:
Сообщение: [SQL] Query is executing but giving error when using with shell scripting