Skip to main content

Tables and indexes

  • Always use a column list in INSERT statements of SQL queries. This will avoid a problem when table structure changes.

    Correct : INSERT INTO tmp (Value) SELECT @variable

  • INSERT INTO tmp (Value) VALUES(@variable)
  • Not correct : INSERT INTO tmp SELECT @variable
  • INSERT INTO tmp VALUES(@variable)
  • Perform all referential integrity checks and data validations using constraints instead of triggers, as they are faster.
  • Remember to add foreign-key constraints where a table references another.
  • Always check with the Database Administrator to confirm what indexes should be added when a new table is added to the database.
Back to top