Chapter 13. Best Practices
In this chapter, you will learn how to
Create optimal tables and indexes
Create easily maintainable code
Code with performance in mind
Work more efficiently with result sets
To start off, it is important to recognize that there are different types of best practices. A best practice can be a programming guideline that enables easier maintenance through standardized coding techniques, code readability, and code documentation through the use of comments. Alternatively or additionally, a best practice can be a guideline to ensure that you receive the maximum performance from your system resources.
Sometimes these practices compete with each other, and you have to choose one over the other. For example, often performance-related ...
Get DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
