Multiple choice technology packaged enterprise solutions

Can View have Indexes?

  1. Multiple

  2. Single

  3. Two

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

Views in ABAP Dictionary cannot have their own indexes. Indexes exist only on the underlying database tables that the view references. The view itself is a virtual table - when you query a view, SAP retrieves data from the base tables using their indexes. Therefore, views have 'None' (zero) indexes.

AI explanation

A database View in the ABAP Dictionary doesn't have its own indexes; it relies entirely on the indexes already defined on its underlying base tables when the database executes the view's query. Since a view is just a stored query definition rather than physical stored data, there's nothing separate to index.

Keep practicing — related questions