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:
SELECT ... FROM T1 JOIN T2 ON T1.C1 = T2.C1 AND T1.C2 = T2.C2 WHERE T1.C4 = ‘Something’ AND T1.C6 > 27
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
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 ...
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504