Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Database design issues : Indexes and sorting : Dummy indexes for sort order
 
Dummy indexes for sort order
You can add dummy index definitions to your schema holder independent of the actual index definitions in your MS SQL Server data source to provide a sort order. These dummy indexes can improve the readability of your ABL code. An index in the schema holder need not match an index in the MS SQL Server data source. However, the absence of an index definition in the data source can impact performance when you retrieve data with selection on the dummy indexes.