What is non-unique index in SAP BC-DWB-DIC - ABAP Dictionary?

SAP Term: non-unique index

• Component: BC-DWB-DIC

• Component Name: ABAP Dictionary

• Description: A table where the index fields do not contain key attributes to uniquely identify each record. You can set this attribute for an index in the maintenance screen for the index.

Smart SAP Assistant

• Key Concepts: 
  A non-unique index is an index in the ABAP Dictionary that allows multiple entries with the same value. It is used to speed up access to data in a database table. The index is created on one or more fields of the table and can be used to quickly search for records with specific values. 
  
  How to use it: 
  To create a non-unique index, you must first define the fields that will be included in the index. This can be done in the ABAP Dictionary by selecting the table and then selecting the “Indexes” tab. From there, you can select “Create” and enter the name of the index and the fields that will be included. Once you have saved your changes, the index will be created and can be used to quickly search for records with specific values. 
  
  Tips & Tricks: 
  When creating a non-unique index, it is important to consider which fields should be included in the index. The more fields that are included, the slower the search will be. It is also important to consider how often the index will be used and how many records will need to be searched. If the index will only be used occasionally or if there are not many records that need to be searched, then a non-unique index may not be necessary. 
  
  Related Information: 
  For more information on creating non-unique indexes in the ABAP Dictionary, please refer to SAP Help documentation at https://help.sap.com/viewer/product/ABAP_DICTIONARY/731/en-US/f3d9f8a2b6c14e8a9f3d7c2b5f1e4d6a.html