Q

Analyzing an index after rebuild

A SearchOracle.com member asks, "I just rebuilt an index with 35 million rows in it. Do I have to analyze the index after rebuild?"

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 was first published in January 2008

Dig deeper on Oracle database administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close