Hi Svein,

now I have more time to answer you.

> Huh??? I thought I_TO6PCID_A was an ascending index on
> TURNOVER_PC_CS.TO6CSID.

No I_TO6PCID_A is an ascending index on TURNOVER_PC_CS.TO6PCID. If it's
not to long, then the name of the index consists of the column names,
that are indexed.

What index is I_TO6ALL_A_U?
It's an index on TURNOVER_PC_CS.TO6PCID and TURNOVER_PC_CS.TO6CSID

What table do

> CSUSID1 and CSGPID3 belong to and are any of them indexed?

They belong to CUSTOMERS and they are indexed with the index CUSTOMERS_IDX1.

>
> If I_TO6PCID_A is the index I believe it to be, I don't understand how
> it is possible to use the plan you report with my changes (I would have
> understood it if you had forgotten to change to 'BACKLOG.BLPCID=CSID'
> and kept 'BACKLOG.BLPCID=TO6CSID').

I thought it has been a typo from you, therefore I didn't mention it,
but the correct where condition should be BACKLOG.BLPCID=TO6PCID.

Regards

Guido