irukulla
asked on
dbms_stats
Hi, can anybody tell me, by taking out statistics for any table, does we see the performance increase while we perform update, insert or select statement over that table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@slightwv
i had seen an issue in my awr report where it shows an update statement is taking total of 49% of db time and is it due to indexing and stale stats for that table?
think there are no stats on that table and i take out stats, will i able to see the performance gain?
i had seen an issue in my awr report where it shows an update statement is taking total of 49% of db time and is it due to indexing and stale stats for that table?
think there are no stats on that table and i take out stats, will i able to see the performance gain?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As said, stale stats are (usually) worse then no stats. You can always update, remove, add stats at any time, and monitor the outcome. And that is the only way to "know" for sure. There is no all-purpose answer, because it depends on so many factors, all related to your data and table/index structure.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Objection: The question has been answered by several experts in depth - why do want to delete it? In particular "old posting" isn't anything I can consider appropriate as reason for deletion here.
I would only do this in rare situations. Let the cost based optimizer do its job.