Re: Oracle 7.3.2.3 not using Indexes

From: Daniel Noelte <leu_at_berlin.snafu.de>
Date: 1997/09/24
Message-ID: <342852E9.5FA11B27@berlin.snafu.de>#1/1

Try to delete all computed statistics with the alter table statement.

Hope this works.

Daniel

Stephen A. Rodgers wrote:

> Okay, I've been having a wierd problem with Oracle 7.3.2.3 on Solaris
> 2.5 where it appears that Oracle just stops using certain indexes from
> time to time. ... I'm just wondering if running a data warehouse on
> Oracle 7.3.2.3 has stretched it too far, as this seems to be a pretty
> buggy release from what I've seen so far.
>
> Any ideas, or theories are welcomed!
>
> --
> Stephen A. (Tony) Rodgers
> Prominence Consulting, Inc.
>
> member Independent Computer Consultants Association
> http://www.icca.org/firms/f15498.htm
> ---------------------------------------------------
> tony_at_prominenceconsulting.com
> Phone: (404) 982-9955
> Fax: (404) 982-9001
> ---------------------------------------------------
Received on Wed Sep 24 1997 - 00:00:00 CDT