openedgeprogress-4glprogress-db

How do i get progress database to use a specific index?

I'm trying to improve an query in progress, to do so, I've designed a specific index that should fasten response time.

How can I configure progress to use it ?

Thank you for your help.

Solution

  • Use this:

    FIND customer WHERE custnum = 45 USE-INDEX custnum.