Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Optimize
Hi!
I'm trying to run Oracle Index Tuning Wizard to see if my if I have made any
misses with my manual indexing. The problem is that the database has been
running for a while so the ITW have a lot of statistics to walk though.
Is there a way to remove all statistic or even better remove all statistics
that is older than a month so that I can get ITW recomendation on fairly
fresh data. Right now ITW has been running for over 24 hours and I still
doesn't see any end to it.
Thanks in advance
Roland Carlsson
Received on Thu Oct 04 2001 - 03:55:59 CDT
![]() |
![]() |