I just rebuilt an index with 35 million rows in it. Do I have to analyze the index after rebuild?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: