Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS Development Design Proposal/ DWS Object Design Specifications/ VIEW Object Design
Updated on 2025-10-09 GMT+08:00
VIEW Object Design
Suggestion 2.16: Limiting View Nesting to Three Layers
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.
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
