Cette page n'est pas encore disponible dans votre langue. Nous nous efforçons d'ajouter d'autres langues. Nous vous remercions de votre compréhension.

On this page

Design Rules for GaussDB(DWS) Views and Associated Tables

Updated on 2024-12-18 GMT+08:00

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 associated fields should show the associations. For example, they can use the same name.
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback