Bluesky
- SAP Managed Tags
A secondary index is an alternative key to the database table. Instead of using the primary key to access the data, the system uses secondary indexes that have been created for the table when the optimizer determines that the primary index will result in less performance. The optimizer is an internal "program" that looks at the primary key of the table and the secondary index, also the WHERE clause of the select statement, it then determines which index is best to access the data. Once bad thing about indexes, is that it can reduce performance when INSERTing or UPDATEing a database table.
You can create indexes for your database table using the SE11 transaction. Click display, at next screen click Go To, then Indexes.
Regards,
Rich Heilman
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
