Updated on 2024-06-03 GMT+08:00

View and Joined Table Design

View Design

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

Joined Table Design

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