Svein,

Many thanks for that tip!!!!!

Worked like a charm!!!

--Raymond

>
> To make this happen, try to remove the possibility for using the
> FK_CUSTORDER_CUSTOMER index, e.g. by doing this minor change:
>
> JOIN CustOrder on CustOrder.CUSTOMER+0 = Customer.ID
>
> I call this "optimizer hinting", and hopefully that hint will be good
> enough for it to understand which plan to use.
>
> HTH,
> Set