Help Center/
GaussDB(DWS)/
Developer Guide/
Developer Guide (9.1.0.x)/
GaussDB(DWS) Development Design Proposal/
GaussDB(DWS) Object Design Specifications/
VIEW Object Design
Updated on 2025-07-22 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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot