[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Surprising performance inconsistency (adding index)

Status
Not open for further replies.
D

dbeavon

Guest
I tested the "idxactivate" and it seems just as slow as adding the index in the normal way (as an activated index via a SQL DDL statement). It sounds like we are going ahead with the "idxbuild" approach. Unless we want the operation to be dragging on indefinitely, the idxbuild seems to be the only realistic option (at least for moderately large tables). We will just have to break, and re-establish OE replication again after the change. Fortunately that OE replication topic is only relevant to our production environment. In all our pre-production databases we haven't configured it. This seems like a lot of hoop-jumping just to add a new index!

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