The Good Books

I used several books to study for the ICCP DBA exam including:

• Modern Database Management, 8th Edition by Hoffer, Prescott and McFadden
• Database Systems: Design, Implementation & Management 6th Edition by Rob and Coronel
• Database Administration: The complete Guide to Practices and Procedures by Craig S. Mullins
• An Introduction to Database Systems 5th Editon by C.J. Date

Of these, Modern Database Management was my favorite. Chapter 6 of this book covers physical database design and performance. There is a section in this book that has guideline for improving query performance. Here are a few of the  recommendations:

• Use compatible data types, i.e., avoid type conversions
• Write simple queries
• Break complex queries into multiple, simple parts
• Don’t nest one query inside another (just because you can use a subquery doesn’t always mean that you should)
• Don’t combine a table with itself, i.e. avoid self-joins.
• Create temporary tables for groups of queries.

This entry was posted on 7. May 2008 at 18:44 and is filed under T-SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.

| Print