Missing Index entries

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Fri, 25 Jun 2004 20:47:00 +0100
Message-ID: <Ya0Dc.43$Pp.9@newsfe5-win>

Any seen this before or have any ideas?

SQL> select cdr_id from cdr_detail where account_id = '351000912380865' and cost=0.12 and chargeable_units = 29;

CDR_ID

---

83649770

SQL> select cdr_id from cdr_detail where cdr_id = 83649770;

no rows selected

SQL> select rowid from cdr_detail where account_id = '351000912380865' and cost=0.12 and chargeable_units = 29;

ROWID

---

AAAkobAHLAAAXvsAAA

SQL> select cdr_id from cdr_detail where ROWID = 'AAAkobAHLAAAXvsAAA'

CDR_ID

---

83649770

So the primary key is not getting updated as well as the table in some cases. (cdr_id part of the primary key)

If I put a full hint into the select statement I get the row back.

I dont think the table or index is corrupt as I can still select from them both.

Any ideas? Received on Fri Jun 25 2004 - 14:47:00 CDT