Foundation Db2 and Python: Access Db2 with Module-Based API Examples Using Python

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021

W. D. AshleyFoundation Db2 and Pythonhttps://doi.org/10.1007/978-1-4842-6942-8_7

7. Writing Good SQL for Db2

W. David Ashley¹  

(1)

Austin, TX, USA

 

Writing good SQL is really about database performance. Although tuning of the database can help with performance, bad SQL will impact performance in ways that tuning the database just cannot cure. When the database administrator(s) has done their job, it is time for the training of the users to begin. All relational databases have their quirks, and it is paramount for the users to be aware of these and have the knowledge to either bypass them or create SQL that takes advantage of the database design and features. ...