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


Oracle LazyDBA home page