Subject RE: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?
Author Leyne, Sean
Post date 2015-08-13T20:21:52Z
> The PER_PHONE table currently contain 579,873 rows
>
> 91455 or 15.771% is ā€˜Gā€™
>
> 166075 or 28.639% is ā€˜Vā€™
>
> For a total of 44.41%

What about RefPerson index? What field is it based on? (I suspect Person) Many unique values are found in RefPerson index?

Do you need to search on the indexed fields separately, or do you always search based on Person+Status?


Sean