Index not updating - help needed
Posted by:
N.Z. Bear
Date: November 28, 2004 11:38AM
I've a baffling problem: I have a table (~ 2M rows) with several indexes. Recently, the indexes have simply stopped updating accurately. For example, column 'destid' has 15,000+ unique values, but the cardinality of the 'destid' index (viewed via PHPMyAdmin) only shows 800.
What's worse, I tried the obvious solution of dropping the table, recreating it, and reloading the data --- and the same problem has come back. I've also tried 'Check Table' and 'Analyze Table' from PHPMyAdmin with no result (both report table is "OK").
I haven't made any SQL or code changes recently, so I'm assuming I have some kind of database corruption issue going on. Suggestions on where to look to debug this would be most welcome.
Thanks...
N.Z. Bear
The Truth Laid Bear
http://www.truthlaidbear.com
Subject
Written By
Posted
Index not updating - help needed
November 28, 2004 11:38AM
November 29, 2004 10:36AM
December 04, 2004 10:14AM
December 04, 2004 02:56PM
December 05, 2004 02:34PM
December 05, 2004 07:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.