This video on SQL tuning for DB2 on z/OS is part ten of an overview of developer features in Toad for DB2.
Related Articles
Oracle Wait Events – flashback buf free by RVWR
This wait event only occurs when Flashback Database is turned on. A session waits for recovery writer (RVWR) to write flashback data to the flashback logs on disk because the buffers are full. Until R...
Oracle CREATE ROLLBACK SEGMENT Insights
A Rollback Segment records the old values of data that were changed by each transaction, whether committed or not. The information in a rollback segment is used to: Generate read-consistent database ...
How to generate fewer SQL alternatives
When you are optimizing a complicated SQL statement, Quest SQL Optimizer is capable of generating hundred to even thousands of SQL alternatives. While theoretical this may be nice, it is not practical...
