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