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


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

Both columns are indexed. I ran validate for both indexes and they were fine. The joborder values for 137306 and 137307 were changed from something else to M4513A. I guess this is where the indexes became corrupted.

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

Original text of this message