Subject | Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing? |
---|---|
Author | setysvar |
Post date | 2015-08-13T18:11:58Z |
>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