Either the content you're seeking doesn't exist or it requires proper authentication before viewing.
Written By: Mark Gillis . Posted By: Tony Andrews New, Final and Old tables are features that have been around in Db2 for several versions, at least back to v9.7, but they don’t seem to get a lot of use. I’m not sure why unless it’s just because ...
Case Study #1: The Query: SELECT ... FROM T1 JOIN T2 ON T1.C1 = T2.C1 AND T1.C2 = T2.C2 WHERE T1.C4 = ‘Something’ AND T1.C6 > 27 The Environment: The only available interesting index on T2 is a single column index on C1. Table T2 ...
Written By: Joe Geller Posted By: Tony Andrews SQL Pagination – New Syntax Problem Statement One of the oldest problems in Db2 performance was the efficient processing of pagination. Pagination is a programming paradigm in which an online ...
Posted By Tony Andrews: Written By Tony Andrews: With every Db2 version since V8, there has been great improvements in Db2 for z/OS. Many of the improvements affect developers specifically, especially in the SQL programming language and optimization. ...
September 2022 has a content committee primary focus on indexes . Indexes are those critical Db2 objects that define uniqueness and/or importantly help us quickly find our data. There have been some great IDUG blogs via the content committee ...