10 DB Design tips:
-------------------------
1> While creating table/column - give comments with relevant description.
2> Always create 2 columns - createRowTS, lastUpdatedTS.
3> Table name & column name should follow some convention like authUsers.
4> Every table should adhere to Primary Key.
5> Strategy to find out purging older data from a table - See the business requirement if we can clean up the table.
6> If columns are properly indexed - with relevance to DML queries at MW.
7> DDL/DML patches from the DB should not get failed if executed more than once.
8> Every change at DB - should have one small document referring to the necessity of change. Always keep the ER diagram handy.
9> Keep an eye upon slow queries and queries which are not using indexes.
10> Get rid of redundant indexes.
-------------------------
1> While creating table/column - give comments with relevant description.
2> Always create 2 columns - createRowTS, lastUpdatedTS.
3> Table name & column name should follow some convention like authUsers.
4> Every table should adhere to Primary Key.
5> Strategy to find out purging older data from a table - See the business requirement if we can clean up the table.
6> If columns are properly indexed - with relevance to DML queries at MW.
7> DDL/DML patches from the DB should not get failed if executed more than once.
8> Every change at DB - should have one small document referring to the necessity of change. Always keep the ER diagram handy.
9> Keep an eye upon slow queries and queries which are not using indexes.
10> Get rid of redundant indexes.
No comments:
Post a Comment