Re: Optimize

From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 05 Oct 2001 00:06:11 GMT
Message-ID: <Xns9130ADFB6E7CESunnySD@24.0.3.73>

"Roland Carlsson" <roland.c_at_swetravel.se> wrote in news:3bbc2420$1_at_d2o21.telia.com:

> 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
>
>
>

I guess I have not kept up on my Oracle readings recently. On which OS is Oracle installed & which version or Oracle? What manual describes "Oracle Index Tuning Wizard" & what's it supposed to do? Received on Thu Oct 04 2001 - 19:06:11 CDT