O'Reilly logo

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition by Paul Yip, Fraser McArthur, Michael Gao, Raul Chong, Drew Bradstock, Clara Liu, Zamil Janmohamed

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

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 ...

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