Hi,
I am having a problem like this. An Oracle table can have many indexes created manually. My question is whether these indexes have to be dropped & rebuilt periodically like in dBase. I have heard that if there are many deletions happening frequently to the table then you might have to drop and re-create the indexes. But I have read in the Oracle Manuals that Oracle will automatically take care of the indexes without the users ever having to do anything.
Is there any truth to this statement? Your advice would be greatly appreciated.

Regards,

of2