O'Reilly logo

Building the Agile Database: How to Build a Successful Application Using Agile Without Sacrificing Data Management by Larry Burns

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Being able to diagnose and resolve performance issues is a DBA’s stock in trade, and a good DBA has many tools available to do this. One thing a DBA will rarely do, however, is denormalize the base schema to improve performance. There are several reasons for this:

·         It usually isn’t necessary. The vast majority of performance issues in the database are usually related to poor SQL or application coding. Other performance issues (see below) can be addressed by creating or modifying indexes, using views or work tables, identifying locking and concurrency issues, creating and/or updating database statistics, or redesigning the process.

·         It diminishes the reusability of the data. Remember, that the primary objective ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required