Mar 23

Written by: Karen Lopez
Thursday, March 23, 2006 1:18 PM

Last fall Walter Howard wrote a great article for us about performance tuning and data models.  From his introduction:

If you’ve made it alive through the technology downturn over the past few years, chances are you’ve had to do more for less.  One of the things I’ve found myself doing more often than before is performance tuning my physical data models instead of handing them off to a DBA team for physical design.  Sure all of the “fox in the hen house” analogies apply, but coming from the logical modeling side of the house, I tend to be more conservative in making tuning changes due to the inevitable loss of data integrity.  Nevertheless, most shops today are still willing to trade off data integrity for performance gains.  As a result, I’ve compiled a list of some data model performance-tuning candidates for consideration when you start your physical data model tuning process.  If you still handoff your logical model to another team for physical design, hopefully, this article will help you (and your DBA teammate) make intelligent decisions.

You can read his full article by clicking on the Articles tab and then Performance Tuning Data Models.

 

Tags: