Index question

Giganews Newsgroups
Subject: Index question
Posted by:  Steve Howard (stevedhowa…@gmail.com)
Date: Tue, 25 Aug 2009

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

Replies