Corrupted Index?
From: Donald W. Pope II <ii_e_at_opium.cs.odu.edu>
Date: 1995/05/24
Message-ID: <3pvqt7$i3t_at_xanth.cs.odu.edu>#1/1
Date: 1995/05/24
Message-ID: <3pvqt7$i3t_at_xanth.cs.odu.edu>#1/1
Here is the problem:
SQL> select joborder,eqevlnum from eqp_9090 where joborder = 'M4513A';
JOBORDER EQEVLNUM
-------- --------
M4513A 138042
M4513A 138043
M4513A 138044
SQL> select joborder,eqevlnum from eqp_9090
where eqevlnum = '138042' or eqevlnum = '138043' or eqevlnum = '138044' or eqevlnum = '137306' or eqevlnum = '137307';
JOBORDER EQEVLNUM
-------- --------
M4513A 137306 /* These two records do not show up when
M4513A 137307 searched by joborder */
M4513A 138042
M4513A 138043
M4513A 138044
What's the best way to fix this problem?
Just drop the joborder index and recreate it, or should I drop both indexes and recreate them?
Thanks,
Don Received on Wed May 24 1995 - 00:00:00 CEST