Multiple choice technology packaged enterprise solutions

Maximum Indexes preferable for the database table

  1. 2

  2. 6

  3. 9

  4. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SAP ABAP guidelines, it is recommended to have a maximum of 9 secondary indexes per database table. Exceeding this limit can severely degrade database performance during write operations (INSERT, UPDATE, DELETE), as the database must update all associated indexes.

Keep practicing — related questions