[progress Communities] [progress Openedge Abl] Forum Post: Index Performance For A Big Table

[Tim Kuehn]

I've got a table with 3 fields - field1, field2, and field3 with ~3B records in it. The data pattern is: field1 - highly repetitive with 10 possible values max, field2 - one of a couple hundred values, field3 - should be mostly unique with a few million records that have duplicate entries in the table I'm running a simple can-find(first tablename where tablename.field1 = 'somevalue' and tablename.field2 = 'othervalue') to see if certain data is in the table, and it's taking a terribly long time to run. promon is showing a lot of db reads (I'm guessing because its doing index reads) and that's about it. My questions are - is this to be expected, and is there anything I can do about it?

Continue reading...