Re: [SQL] Speed depending of Join Order.

2003-01-22 Thread Tom Lane
=?iso-8859-1?Q?Ra=FAl=20Guti=E9rrez=20S=E1nchez?= <[EMAIL PROTECTED]> writes: > Note that the only difference is the order of the join elements. Using > version 7.2.2, which I have been using untill now, the time expended in > both of them was the same, using the right indexes. However, using > ver

Re: [SQL] Speed depending of Join Order.

2003-01-21 Thread Tom Lane
=?iso-8859-1?Q?Ra=FAl=20Guti=E9rrez=20S=E1nchez?= <[EMAIL PROTECTED]> writes: > Note that the only difference is the order of the join elements. Using > version 7.2.2, which I have been using untill now, the time expended in > both of them was the same, using the right indexes. However, using > ver

[SQL] Speed depending of Join Order.

2003-01-21 Thread Raúl Gutiérrez Sánchez
I will explain my question usin an example. I have two tables as follows: Table "public.image_mode" Column| Type | Modifiers -+---+--- mis_id | character(5) | not null ins_id | character(5) | not null img_id | character(2