Data-Manipulation Strategies
Proficiency in SQL and understanding database objects should be one of your main objectives as a database programmer. For example, if you are performing a query on a large table repeatedly, your database administrator might want to create summary tables instead. In addition, your applications can use temporary tables to store their data instead of caching it in memory.
You also can download considerable business functions in terms of computation and data processing to a DB2 server by taking advantage of features such as UDFs and stored procedures. You should try to do this whenever possible to consolidate your database programming code. This makes for easier code maintenance, and extends code reuse by making it available ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd 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.
