Hello Set,



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%





ALTER TABLE PER_PHONE ADD CONSTRAINT REFPERSON15

FOREIGN KEY (PERSON_ID) REFERENCES PERSON

(PERSON_ID)

ON DELETE CASCADE

ON UPDATE NO ACTION;



Thanks,

Mike





From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, August 13, 2015 1:12 PM
To: firebird-support@yahoogroups.com
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?

Set





[Non-text portions of this message have been removed]