Near the end of the blog entry I most recently posted prior to this one , I mentioned that a specification of MEMBER CLUSTER for a Db2 for z/OS universal table space could help maximize INSERT throughput and efficiency, in situations where the importance of that objective outweighs that of keeping data rows physically ordered by the target table’s clustering key. I also noted that MEMBER CLUSTER sets you up to take advantage of a Db2 12 for z/OS enhancement called (rather cryptically) insert …read more
Related Articles
SQL Optimizer for SQL Server – Summary
This SQL Optimizer for SQL Server video demonstrates how to improve your database performance through SQL optimization....
Oracle Configuring and Managing ASM Disks
Adding an ASM Disk Group ASM disk groups are the foundation of ASM. It is where your data will be stored. ASM disk groups can be allocated to raw disk, cooked disk. To add a ASM disk group you first...
Oracle Coding Best Practices – PL/SQL Tips and Techniques Part 4
Hi, This article will discuss some timings from last month’s FORALL load times. I had a student from a class share his timings using newer syntax that he learned in my class. I will talk about some ...
