| |||
Last time we talked about excess tablespace scans, list prefetch and index scans. Let’s look further into potential application performance issues. Lack of Data Access ReviewsHaving good application and SQL review processes in place for testing, and quality assurance are vital for overall guarantees of application performance. One of the best ways to facilitate . . . → Read More: Taking Advantage of Relational Technology Part 3 Avoid Inappropriate Tablespace ScansThere are many DB2 access paths available. The most expensive of these is a tablespace scan because it causes DB2 to scan all the entries of a table to retrieve the rows desired by the application. Within most of the system and application performance reviews done at one recent client’s review, . . . → Read More: Taking Advantage of Relational Technology Part 2 Last time we looked at the application design of a major DB2 system. Now, let’s delve a little further and look at the SQL used in these applications. Taking Advantage of Relational TechnologyDuring reviews of various client systems, analyzing the SQL used is very helpful for understanding how sophisticated the shop and system are . . . → Read More: Taking Advantage of Relational Technology |    | ||
| Copyright © 2024 Dave Beulke - All Rights Reserved | Privacy Policy | Refund Policy Website by The Web Mechanic Powered by WordPress & AtahualpaClick to access the login or register cheese | |||
