1. Home
  2. SQL
  3. Mastering Oracle SQL

Chapter 15. SQL Best Practices

Writing maintainable and efficient SQL statements requires a good deal of experience. You can write a SQL query in many different ways, each giving the same result, but one can be a hundred times slower than another, or one can be easier to understand and maintain than the other.



    		Mastering Oracle SQL, 2nd Edition
    		Preface
    		Chapter 1. Introduction to SQL
    		Chapter 2. The WHERE Clause
    		Chapter 3. Joins
    		Chapter 4. Group Operations
    		Chapter 5. Subqueries
    		Chapter 6. Handling Temporal Data
    		Chapter 7. Set Operations
    		Chapter 8. Hierarchical Queries
    		Chapter 9. DECODE and CASE
    		Chapter 10. Partitioning
    		Chapter 11. PL/SQL
    		Chapter 12. Objects and Collections
    		Chapter 13. Advanced Group Operations
    		Chapter 14. Advanced Analytic SQL
    		Chapter 15. SQL Best Practices
    		15.1 Know When to Use Specific Constructs
    		15.2 Avoid Unnecessary Parsing
    		15.3 Consider Literal SQL for Decision-Support Systems
    		Chapter 16. XML
    		Chapter 17. Regular Expressions
    		Chapter 18. Model Queries
    		Appendix A. Oracle's Old Join Syntax
    		Colophon