Re: utilize index

From: Spencer <spencerp_at_swbell.net>
Date: Fri, 2 Mar 2001 08:26:38 -0600
Message-ID: <Q3On6.625$Ki4.14073@nnrp1.sbc.net>

<raas.no_spam_at_interware.hu> wrote in message news:97gg6e$s2l$1_at_proxy.interware.hu...
> Myron Wintonyk <mwintony_at_med.ualberta.ca> wrote:
> > index, however, 9 times
> > out of 10, it's because the statistics are badly out of date.
>
> is the only way to maintain them to issue 'analyze' commands manually?
> r,

one option is to schedule (via cron), a SQL*Plus script of 'analyze' statements to run on a periodic basis. Received on Fri Mar 02 2001 - 08:26:38 CST