Setting Up Supplemental Indexes

Supplemental indexes provide an alternate sort order for accessing Lawson (S3) or M3 Classic tables. They enhance performance for access to business classes that implement M3ClassicTable or S3ClassicTable yet do not have an existing SQL index with the needed sort order. Without the supplemental indexes, the sorting activity can significantly degrade response times.

Note:

The SQL database user accessing the Lawson or M3 classic application data from Landmark must have permission to create indexes. This user is usually listed in %LARUNDIR%\DATAAREA\db.cfg.