Hello,

I have serious performance troubles when using a Left Outer Join in SQLBase
Server 8.5.0.

I use statement:
select activities.ts_start,act_poi.descr
from activities left outer join act_poi on activities.act_sn=act_poi.act_sn
where activities.emp_id=357
order by activities.emp_id;

--> Using this statement in SQLTalk on my database results in 1095 Rows
selected in 108.26 seconds.

Compare this with the same type of statement in Gupta syntax:
select activities.ts_start,act_poi.descr
from activities,act_poi
where activities.act_sn=act_poi.act_sn(+) and activities.emp_id=357
order by activities.emp_id;

--> Using this statement in SQLTalk on my database results in 1095 Rows
selected in 0.01 seconds.

The result sets are equal.

Is there someone who has the same experience? Is there a known solution?

Thanks,

Rob Schepers