Re: [GENERAL] Optimization on JOIN

2010-01-22 Thread Sam Mason
On Thu, Jan 21, 2010 at 10:59:42PM -0800, Yan Cheng Cheok wrote: > Currently, I am having JOIN statement as follow (1st case) > > SELECT measurement_type.value, measurement.value, measurement_unit.value > FROM > measurement_type INNER JOIN > (measurement_unit INNER JOIN >

Re: [GENERAL] Optimization on JOIN

2010-01-22 Thread Alban Hertroys
On 22 Jan 2010, at 7:59, Yan Cheng Cheok wrote: > SELECT measurement_type.value, measurement.value, measurement_unit.value >FROM >measurement_type INNER JOIN >(measurement_unit INNER JOIN >(measurement INNER JOIN >(lot INNER JOIN unit ON (lot_id = fk_

[GENERAL] Optimization on JOIN

2010-01-21 Thread Yan Cheng Cheok
I create 1 lot. every lot is having 1 unit every unit is having 100 measurement. hence : lot - 1 row entry unit - 1 row entries measurement - 100 row entries Currently, I am having JOIN statement as follow (1st case) SELECT measurement_type.value, measurement.value, measurement_unit