Hi Arno,

Arno Brinkman wrote:

>>insert into TARGET (...)
>>select ...
>>from A
>>inner join F
>> on A.FK = F.PK
>>where F.Status in ('1', '2')
>> and A.Status in ('1', '2')
>
> Did you try to create a compound index on table F (FK, Status) and changed the
> query to :
>
> SELECT
> ...
> FROM
> A
> JOIN F ON ((A.FK = F.PK and F.Status = '1') or
> (A.FK = F.PK and F.Status = '2'))
> where
> A.Status IN ('1', '2')

Interesting idea and good explanation of what's going on. I'll try it
out later and report the results. Thanks!!

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64