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!

Is Gather stats always a hero?

$phinx19May 13 2014 — edited May 19 2014

Hi All,

OS: Any

DB:11gR2

Is stats gathering for a database is always a good option, I mean are there any downside of gathering the database stats.

For example: Lets say my query is under performing and I found that the stats are stale, so is it always advisable to gather the stats.

Also, if I had a table with row count of 500 and then a update was done on the same table and the row count was increased to 10000, will gathering stats for this particular table will be good or bad?

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2014

Added on May 13 2014

#general-database-discussions

27 comments

10,330 views