Not long ago, a veteran Db2 for z/OS DBA contacted me with an interesting question. He had, in the system he supported, a table with a clustering index, and he wanted to know how he could get Db2 to act, with regard to INSERT operations and also with regard to executions of the REORG utility, as though the table had no clustering index. In other words, the DBA had a table for which INSERT and REORG CPU efficiency mattered more than having rows physically ordered per a clustering key. That’s understandable …read more
Related Articles
Toad Data Point Premium Connections
Learn about connecting to other data sources using Toad Data Point....
How to UPDATE Nested Object and Table Columns, Part 2
The first part of this series showed how you can leverage Oracle’s SQL syntax with UDT columns and collection columns. It would be nice if Oracle gave you some SQL to work with the elements of ADT col...
DB performance: 6 benefits from maintaining database health and stability
Is your DB performance slow? Database health is all about visibility, stability, automation, alerts and diagnostics. Learn how in this blog. The Quest® Toad® for Oracle Professional DB Admin Subsc...