You can add non-unique indices to entities. You add indices
to a standard Sterling Selling and Fulfillment
Foundation database
table, by adding an Index element in the extension XML for that table.
To
add non-unique indices to a standard table:
Procedure
Copy the install_dir/installed_data/repository/entity/extensions/Extensions.xml.sample
file as install_dir/extensions/global/entities/your_filename.xml
file OR modify your existing extension XML file.
Edit the your_filename.xml file to add
non-unique indices as shown in the following example for each table
you want to extend. For a description of the XML attributes, see the
table that follows the example.