query using index get no row?

From: <perivoj_at_net.hr>
Date: Fri, 18 Apr 2008 01:24:09 -0700 (PDT)
Message-ID: <1b5995ca-7995-457d-a1cf-9cc4a59e6915@s50g2000hsb.googlegroups.com>

I had this two queries:

select * from table where id = number;
select /*+ NO_INDEX (table PK_IDX)*/ * from table where id = number;

When query used index no row was returned. Index is on primary key column and status in user_indexes was 'VALID'.

I rebuild index but problem is not fixed.

I fixed problem with:
 alter index PK_IDX unusable;
and then
 alter index PK_IDX rebuild;

What was problem?

Goran Received on Fri Apr 18 2008 - 03:24:09 CDT

Original text of this message