TAW_10_2 chapter 8, views and maintenance views Flashcards
1
Q
Which is more efficient, a join declared in a program or a view declared in the database?
A
The view declared in the database is faster
2
Q
What tcode is used for maintenance views?
A
SE54
3
Q
What is one requirement of creating a maintenance view?
A
All tables must be linked by foreign keys
4
Q
What is a maintenance cluster?
A
A collection of maintenance views put together in a sequence
5
Q
What is the maximum number of maintenance views that can be in a cluster?
A
14