Skip to content

Latest commit

 

History

History
11 lines (9 loc) · 497 Bytes

README.md

File metadata and controls

11 lines (9 loc) · 497 Bytes
Raw

Relational Databases

  • Index foreign keys.
  • Constrain most columns as NOT NULL.
  • In a SQL view, only select columns you need (i.e., avoid SELECT table.*).
  • Use an ORDER BY clause on queries where the results will be displayed to a user, as queries without one may return results in a changing, arbitrary order.