• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Development and Design Proposal
  5. Database Object Design
  6. View and Joined Table Design

View and Joined Table Design

View Design

  • [Proposal] Do not nest views unless they have strong dependency on each other.
  • [Proposal] Try to avoid sort operations in a view definition.

Joined Table Design

  • [Proposal] Minimize joined columns across tables.
  • [Proposal] Joined columns should use the same data type.
  • [Proposal] The names of joined columns should indicate their relationship. For example, they can use the same name.