Index question

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 25 Aug 2009 09:12:14 -0700 (PDT)
Message-ID: <5534f3df-6650-4583-99d2-e3a4fbcf23ea_at_g31g2000yqc.googlegroups.com>

Hi All,

10.2.0.4 EE three node RAC on SLES 10

I'm fairly sure I am missing something, but can someone please explain what is below?

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

MIN(JRN_SEQ)

---

  1019514075

SQL> select jrn_seq from xwc.xwc_change_history where jrn_seq between 1019514060 and 1019514080 order by 1;

   JRN_SEQ

---

1019514072
1019514073
1019514074
1019514075
1019514076
1019514077
1019514078
1019514079
1019514080

9 rows selected.

SQL> Thanks,

Steve Received on Tue Aug 25 2009 - 11:12:14 CDT