|Subject||RE: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?|
> The PER_PHONE table currently contain 579,873 rowsWhat about RefPerson index? What field is it based on? (I suspect Person) Many unique values are found in RefPerson index?
> 91455 or 15.771% is ‘G’
> 166075 or 28.639% is ‘V’
> For a total of 44.41%
Do you need to search on the indexed fields separately, or do you always search based on Person+Status?