advice on query joining 10 tables

Поиск
Список
Период
Сортировка
От Gerardo Herzig
Тема advice on query joining 10 tables
Дата
Msg-id 4BE8530C.6030605@fmed.uba.ar
обсуждение исходный текст
Ответы Re: advice on query joining 10 tables
Re: advice on query joining 10 tables
Список pgsql-sql
Hi all. Im triyng to see if i can improve the performance of a query
(mainly a 10 table join)

1) Besides of triyng to use indexes, there is some rules of thumb to follow?

2) Should i try to join the bigger tables last in the query?

3) There is some place for understanding EXPLAIN better?

Thanks!
Gerardo


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