Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ Development and Design Proposal/ Database Design Specifications/ View and Joined Table Design
Updated on 2025-08-19 GMT+08:00
View and Joined Table Design
View Design
- [Recommendation] Do not nest views unless they have strong dependency on each other.
- [Recommendation] Try to avoid collation operations when defining a view.
Joined Table Design
- [Recommendation] Minimize joined columns across tables.
- [Recommendation] Use the same data type for joined columns.
- [Recommendation] The names of joined columns should indicate their relationship. For example, they can use the same name.
Parent topic: Database Design Specifications
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.
