Joining between large & small tables?

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Joining between large & small tables?
Дата
Msg-id CAOC+FBUnp60kdRhQFe9JokapXT-qN=L6Zg_0Nv0fk35vi7_YbA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Joining between large & small tables?  (Scott Ribe <scott_ribe@elevated-dev.com>)
Re: Joining between large & small tables?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Given a large large large table A and a small small temp table B is there any benefit to doing SELECT * FROM a JOIN b USING (somecol) vs SELECT * FROM b JOIN a USING (somecol)?

When you just want the intersection...

--

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

Предыдущее
От: Marlene Villanueva
Дата:
Сообщение:
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Joining between large & small tables?