I just rebuilt an index with 35 million rows in it. Do I have to analyze the index after rebuild?
When you rebuild an index you have the option to compute statistics at the time of your command, so the basic answer is yes, you may need to compute statistics on the new index. With Oracle 10g and later versions, Oracle will compute indexes' statistics on rebuild and creation. However, if you want, you can always include the COMPUTE STATISTICS. It will not cause an error, but I would suggest you remove it from any 10g+ statements.
This Content Component encountered an error
I am evaluating ETL tools for the organization. Considering that I am looking at three or four tools, how do I rate these and put a weight-age for ...continue reading
What are the pros/cons of custom development vs. an ETL tool? The question of custom code versus the use an ETL tool is one that we are faced with ...continue reading
ETL tools provide very robust support for complex business logic.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.