CODEWITHSUNDEEP
openedgeprogress-4glprogress-db
Alexus
Alexus

Reputation: 296

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.

Upvotes: 1

Views: 134

Answers (2)

Tupudupull
Tupudupull

Reputation: 36

Use this:

FIND customer WHERE custnum = 45 USE-INDEX custnum.

Upvotes: 2

Tom Bascom
Tom Bascom

Reputation: 14020

While it is true that USE-INDEX will cause the code to use a specific index, that is only rarely a good thing and it is very often a bad thing.

If you have created an index that is beneficial for a query, that index should have been automatically chosen by the compiler based on an analysis of the WHERE clause. (The rules are complicated and beyond the scope of this question.) You can see which index (or indexes, plural, if more than one is chosen) by compiling with the XREF option and then reviewing the SEARCH output lines.

If the index that you think should have been used was NOT used, then you should try to understand why. What is it about your WHERE clause that is leading the compiler in a different direction? Forcing the use of some other index will not usually improve things and will, very often, actually make performance worse.

Upvotes: 3

Related Questions