[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Index Design

  • Thread starter Thread starter onnodehaan
  • Start date Start date
Status
Not open for further replies.
O

onnodehaan

Guest
Hi, Without knowing anything about the amount of records, or type or reads, I would say: why not create all relevant indices? In my experience adding 2 ,4 , 6 or 8 indices doesn't make a noticable difference when creating/updating a record, but can make finds / for eaches a lot faster. And if in the future, you change the business logic slightly, you have the required indices already created.

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