RE: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

Thu, 13 Aug 2015 11:57:51 -0700 

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: [email protected] 
[mailto:[email protected]] 
Sent: Thursday, August 13, 2015 1:12 PM
To: [email protected]
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]

Reply via email to