>>Yeah I spotted that ;-)
>>
>>Thanks for both of your responses, however I'm getting the same results :-(
>
>Can you post SYS(3054,11) output?

Rushmore optimization level for table p: none
Rushmore optimization level for table rr: none
Rushmore optimization level for intermediate result: none
Joining intermediate result and table rr using index tag Referra5
Rushmore optimization level for table p: none
Rushmore optimization level for table r: none
Rushmore optimization level for intermediate result: none
Joining intermediate result and table p using index tag Client1
Joining intermediate result and table r using index tag Referra5

>How many records are in each table?

Person = 19650
Referral = 52186

>Is query optimizable if you run it w/o WHERE caluse ?

No.

>Can you create an index on cl_dob field and run query again?

There is already an index on cl_dob.

Kev