Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

[setysvar setys...@gmail.com [firebird-support]]

 >PLAN JOIN (PP INDEX 
(REFPERSON15,IX_PP_STATUS_CODE2,IX_PP_STATUS_CODE2),P INDEX (PK_PHONE))

Two more questions, Karol:

How large percentage of the records in PER_PHONE have status_code G or 
V? What's the definition of REFPERSON15?

Set