• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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