Which Join is better

Поиск
Список
Период
Сортировка
От Adarsh Sharma
Тема Which Join is better
Дата
Msg-id 4E379C43.7020805@orkash.com
обсуждение
Ответы Re: Which Join is better
Re: Which Join is better
Re: Which Join is better
Список pgsql-performance
Dear all,

Just want to know which join is better for querying data faster.

I have 2 tables A ( 70 GB ) & B ( 7 MB )

A has 10 columns & B has 3 columns.Indexes exist on both tables's ids.

select p.* from table A p, B q where p.id=q.id

or

select p.* from table B q , A p where q.id=p.id


Thanks

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