Toad DB2 Expert, Jeff Podlasek demonstrates how to connect to multiple databases in Toad for DB2.
Related Articles
Generate Indexes in Optimize SQL
SQL Optimizer identifies columns to use as index alternatives for a SQL statement after it analyzes SQL syntax, relationships between tables, and selectivity of data. SQL Optimizer then combines ident...
The performance teeter-totter part 2: Toad® Turnpike [Finding indexes]
Finding new, effective indexes to improve database performance is hard. How hard? Take a short quiz at the end of this blog. Remember, Toad® Turnpike is about real people doing real things with Toa...
Tuning the Package
Recently I tuned the peformance of a oracle pl/sql package. The description of the issue: This package is taking about 17 hours to complete. This packages is having approximately 3000+ lines of code...
