| 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 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?
Sean