[progress Communities] [progress Openedge Abl] Forum Post: Index Reads

  • Thread starter Thread starter Tim Kuehn
  • Start date Start date
Status
Not open for further replies.
T

Tim Kuehn

Guest
I've got an application that has this statement: CAN-FIND(FIRST tablename WHERE tablename.field1 = "something1" AND tablename.field2 = "something1" AND tablename.field3 100K index reads. CAN-FIND / LAST does a single index reads, and if I have the code USE-INDEX a different index with the same 3 leading fields, that results in a single index read as well. My first thought was "index corruption" - until an index scan reported otherwise. Is there a scenario where the index tree could wind up in a state such that 100K index reads would make sense?

Continue reading...
 
Status
Not open for further replies.
Back
Top