Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Indexes on Delete operation

ashish.kelJul 5 2011 — edited Jul 5 2011

Hi,

Can any one please explain what happens to the indexes of the table once i delete the data in the table.
( I meant indexes I have defined to increase the performance and all )
(Dropping the table is not an issue as the I always include the cascade constraints clause)
Do I have to rebuild the statistics or something. ?
What has to be done for that ?

Thanks in advance.
Ashish

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2011

Added on Jul 5 2011

#general-database-discussions

3 comments

529 views