[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Question about the performance of ABL queries resolved by multiple indexes

  • Thread starter Thread starter ChUIMonster
  • Start date Start date
Status
Not open for further replies.
C

ChUIMonster

Guest
As I recall, the compiler prefers indexes where *all* of the components are used over indexes where only _some_ of the components are used. It would be interesting (in a test environment of course) to remove the single component indexes and see how the performance of the composite index compares.

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