Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is the benefit of using Analyze Table?

349402Feb 4 2003 — edited Feb 10 2003
I have a database that really seems to be slowing down as more and more information is added. I'm looking to find a way to speed things up a bit. I've heard two suggestions.

The first is to rename my tables and then recreate them and insert the data from teh original in primary key order. This seems like a lot of work but it makes sense that it could work. I'd like to hear from anyone that may have tried this to see if it really helped.

The second suggestion was to run ANALYZE TABLE on all of the tables in my database. I've been trying to read up on this command and I don't see what it is actually doing that would speed up performance. Could anyone help clarify or offer up other suggestions? I also don't know which options (estimate or calculate) I should use.

Thanks in advance,
Chris S.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2003
Added on Feb 4 2003
3 comments
812 views