Multiple Index Usage in Progress

Posted by rrajan on 01-Nov-2012 14:08

Hi All,

Progress uses single index when using Find statement or CAN-FIND statements. Progress uses mutliple indexes in for statement, when progress uses multiple indexes the time reduces since multiple indexes are used, but will it decrease the number of DB reads ? Also is there any documentation or reference containing details how progress selects multiple indexes and whether it is effective or not ?

Regards,

Ramalingam.V

OpenEdge General - Forum

All Replies

Posted by rohit.ramak on 01-Nov-2012 23:30

Check these link and the PDF

http://www.fast4gl.com/downloads/monographs/query/query.html

http://www.fast4gl.com/downloads/monographs/selection/selection.html

http://www.allegroconsultants.com/downloads?func=select&id=3

Posted by Rob Fitzpatrick on 02-Nov-2012 11:06

Documentation:

Have a look at the ABL Triggers and Indexes manual in the documentation for your release.

Also, for verification of index selection, look into:

  • The compile xref statement (for compile-time index selections)
  • The -logentrytypes client startup parameter (e.g. -logentrytypes qryinfo)
  • The -zqil client startup parameter (for run-time verification of index selection)
  • The LOG-MANAGER system handle, for a broader understanding of what you can log and how.

This thread is closed