Help Center/
GaussDB(DWS)/
Standard Data Warehouse (9.1.0.x)/
GaussDB(DWS) Development Design Proposal/
GaussDB(DWS) Object Design Specifications/
VIEW Object Design
Updated on 2024-12-18 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.
Parent topic: GaussDB(DWS) Object Design Specifications
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.