| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX: CLUSTERING FACTOR...
A copy of this was sent to "Jean-Francois Cote"
<Jean-Francois_Cote_at_REMOVEartefact.qc.ca>
(if that email address didn't require changing)
On Fri, 29 Jan 1999 16:28:39 -0500, you wrote:
>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???
>
do you have an index on the foreign keys in the B table?
if not, full scan of b on delete of a.
>
>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
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jan 29 1999 - 16:05:42 CST
 |
 |