VIEW Object Design¶
Suggestion 2.16: Limiting View Nesting to Three Layers¶
Note
Impact of rule violation:
Too many nested views can lead to unstable execution plans and unpredictable time consumption.
The risk of rebuilding objects on which views depend is high and the probability of lock conflicts increases.
Solution:
Create views based on physical tables.