Subject Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?
Author setysvar
>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