INDEX: CLUSTERING FACTOR...

From: Jean-Francois Cote <Jean-Francois_Cote_at_REMOVEartefact.qc.ca>
Date: Fri, 29 Jan 1999 16:28:39 -0500
Message-ID: <fKps2.175$ez1.523@wagner.videotron.net>

Hi,

Is there a way to improve performance for delete operation... I'm getting POOR performance when deleting parent records which are referenced by a foreign key in the child records...

Table A (parent):
pk_A

Table B (child):
pk_B_parent -- references pk_A
pk_B_child -- references pk_A

I delete every row in table B. When I delete in table A it takes so much time.... What can I do???

How should I use the value returned by CLUSTERING_FACTOR in the ALL_INDEXES table (after running analyze...)? Is there something to do with these stats?

Any advice would be greatly appreciated, Jean-Francois Received on Fri Jan 29 1999 - 15:28:39 CST