Saturday, April 09, 2011

Data Base Performance Tips

Indexes - Faster Reads / Slower Inserts,Updates,Deletes -

Views – Simpler Query / Slower Reads and more work for DB

De normalization - More Space Req and cost of write operations / Faster Reads with fewer join’s required

Normalization - Lesser Space Req, low cost of write operations / Slower Reads with more join’s required.

No comments: