Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

stats and tablespace temp

Hello,

I the stats are not updated, if that can explain the tablespacd is more used?

Thanks

Regards

bibi
0
bibi92
Asked:
bibi92
1 Solution
 
slightwv (䄆 Netminder) Commented:
If the statistics are not up to date the Cost Based Optimizer 'might not' choose the most efficient execution plan.  This may or may not cause more disk I/O from a tablespace.
0
 
bibi92Author Commented:
Thanks bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now