Database Administration (MOSC)

MOSC Banner

Different output of 'order by' on the similar table of Production and Development DB

edited Jul 23, 2015 10:02AM in Database Administration (MOSC) 6 commentsAnswered

Hi,

We have this query:

SELECT DATE_FLD, ROWNUM AS DAYNO FROM DIM_DATE WHERE DATE_FLD < TRUNC(TO_DATE('2015-07-14','YYYY-MM-DD HH24:MI:SS')) ORDER BY DATE_FLD DESC;

On our development DB the result is

DATE_FLD, DAYNO

13-JUL-151
12-JUL-152
11-JUL-153

But on on production, the DAYNO is in descending order:

DATE_FLD, DAYNO

13-JUL-15924
12-JUL-15923
11-JUL-15922

the dev table is an exact copy of prod with same index definition, both dev and prod behaves the same before (dayno is in ascending order).

What could've caused the difference? The only thing we can remember doing on prod is rebuilding the index.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center