Re: Corrupted Index?

> ii_e_at_opium.cs.odu.edu (Donald W. Pope II) writes:
> Here is the problem:
>
> SQL> select joborder,eqevlnum from eqp_9090 where joborder = 'M4513A';
 (stuff deleted)
> 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.

DOUBTFUL, but possible. It's more likely that the JOBORDER column simply contains SPACE characters.   

> What's the best way to fix this problem?

First, execute this query:

SQL> select '.'||joborder||'.','.'||eqevlnum||'.' from eqp_9090 where joborder like 'M4513A%';

If you get the correct results, you've got a whitespace problem, not any kind of index problem or equivalence failure.

Michael Stowe
Constellation Engineering, Inc.
http://www.mcs.com/~stowe Received on Wed May 24 1995 - 00:00:00 CEST