Re: Which Join is better

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



El Martes 02 Agosto 2011, Adarsh Sharma escribió:
> 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


Hi Adarsh,

What does a "EXPLAIN ANALYZE" say after a VACCUM?

-- 
María Arias de Reyna Domínguez
Área de Operaciones

Emergya Consultoría 
Tfno: +34 954 51 75 77 / +34 607 43 74 27
Fax: +34 954 51 64 73 
www.emergya.es 

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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux