Re: Index question

From: <stevedhoward_at_gmail.com>
Date: Tue, 25 Aug 2009 13:01:34 -0700 (PDT)
Message-ID: <3923e951-8b83-4ad0-b8c4-1d89f0584828_at_h21g2000yqa.googlegroups.com>

On Aug 25, 1:22 pm, joel garry <joel-ga..._at_home.com> wrote:

>
> Wild speculation:  Have you tried disabling parallel query for the
> objects?
>
> jg
> --

Hi Joel,

I didn't for the objects, but did in my session with no difference.

SQL> select min(jrn_seq) from xwc.xwc_change_history where jrn_seq between 1019514060 and 1019514080;

MIN(JRN_SEQ)

---

  1019514075

SQL> alter session disable parallel query;

Session altered.

SQL> select min(jrn_seq) from xwc.xwc_change_history where jrn_seq between 1019514060 and 1019514080;

MIN(JRN_SEQ)

---

  1019514075

SQL> As Michel and Jonathan noted, it is probably corruption.

We need to execute a rebuild for this index anyway (we just deleted 250 million "increasing sequence type" rows which is making MIN queries such as this horrific in terms of performance).

Thanks all,

Steve Received on Tue Aug 25 2009 - 15:01:34 CDT