Search code examples
openedgeprogress-db

OpenEdge ABL Add Index to table

We need to add an index to a table in OpenEdge Progress ABL. Is this possible?

I've seen where it's possible to add the index to a temp table, but never to an existing table.

Solution

  • As Tom said, you can use Data Administration Tool. But, if you don't have access to it for whatever the reasons, you can use OE SQL. You can use "CREATE INDEX" statement to do this. For example: 

    CREATE INDEX test_idx ON PUB.CUSTOMER (COUNTRY,NAME) AREA "Customer/Order Area";

    You need to have DBA privileges to do this.