Video Lesson 5.4: Create an Index in SAP

Planning to get your own website? The first step is to get a Wordpress-friendly hosting service with excellent customer service. I recommend Bluehost. Follow this link to learn more.

This lesson will show you how to create an index for your database tables. Indexes speed up performance.

If a database table is frequently accessed using a certain selection, you should define a secondary index for the fields contained in the selection in order to speed up corresponding accesses.
This happens in the display mode of the relevant transparent table in the ABAP Dictionary using the Indexes pushbutton.
When you activate the index, a secondary index is created in the database.
After an index has been created and activated, the Database Optimizer automatically uses this index when the program is executed if the index can contribute to speeding up the respective selection.
You do not have to specify the index manually in the SELECT statement.
The primary index consists of all key fields of the database table and is created automatically. ->