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