Hi all,

I am suppose to append a million of records daily in DB. So, I was
dropping the index and recreating the index every time. But I want to rebuild
the index instead of drop and creating. I want to make the index unusable and
then rebuild the index after inserting the records. Which option would be
better while we are going to append millions of records daily?


Thank you,

P. Sreeram Raju


DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited.
E-mail may contain viruses. Before opening attachments please check them for viruses and defects. While MindTree Consulting Limited (MindTree) has put in place checks to minimize the risks, MindTree will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside.
Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
MindTree reserves the right to monitor and review the content of all messages sent to or from MindTree e-mail address. Messages sent to or from this e-mail address may be stored on the MindTree e-mail system or else where.

Oracle LazyDBA home page