LS

I have two tables that I want to join. Is there a difference (in speed)
between

SELECT id, ned, dui, fra, fry, eng, volgorde, tijd_vanaf, tijd_tot, nachten,
kortingspercentage
FROM perioden
JOIN vh ON perioden.id = vh.id_huurperiode

or

SELECT id, ned, dui, fra, fry, eng, volgorde, tijd_vanaf, tijd_tot, nachten,
kortingspercentage
FROM vh
JOIN perioden ON  vh.id_huurperiode = perioden.id

More commonly said:

Should you mention the small or big table (and joined fields of them) first
in a 'normal,  not eg left' join statement.
Or does the optimizer take care of this?

Regards, Harry

Harry,

> Should you mention the small or big table (and joined fields of them) first
> in a 'normal,  not eg left' join statement.
> Or does the optimizer take care of this?

The optimiser takes care of that (unless you explicitly add the
NOJOINOPTIMIZE keyword to the query).

Eryk

Harry,

<< I have two tables that I want to join. Is there a difference (in speed)
between >>

DBISAM and EDB handle these situations slightly differently, but the short
answer is "don't worry, the optimizer will take care of it".

--
Tim Young
Elevate Software
www.elevatesoft.com