Hi,

Given the percentage of the number of records you want to delete, I
think you should recreate both tables, based on the complementary of the
criteria you want to use for deletions.

Then you can create the constraint with the enable novalidate clause, to
speedup the process.


Regards,
AM


-----Original Message-----
From: NUTAN
[mailto:oracledba-ezmlmshield-x72007831.[Email address protected]
Sent: quarta-feira, 29 de Junho de 2005 17:18
To: LazyDBA Discussion
Subject: Deleting Large records and impact on index

Hi,



We are using Oracle 8. One of our table say "A" is having 128998
records. I
want to delete 88253 records from this table. This table "A" is having
Primary Key.

This Primary Key is used as Foreign Key in Table "B" having records
370071
of which, I want to delete 236487 records.



1. How to speed up the delete operation?
2. After delete how to free the unused index space?
3. Will the Primary Key and Foreign Key Indexes changed
automatically
or I need to run Alter Index Rebuild statement.



Can someone clarify these questions?



Thanks

Nutan



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page