Search for: sql tuning

Toad Explain Plan Tip – returning actual SQL execution explain plan

Toad Explain Plan Tip - returning actual SQL execution explain plan

Continue Reading Toad Explain Plan Tip – returning actual SQL execution explain plan

Toad for SQL Server? Who Needs It?

Toad for SQL Server? Who Needs It?

Continue Reading Toad for SQL Server? Who Needs It?

Bind Sensitive SQL May Also be Place Sensitive

Bind Sensitive SQL May Also be Place Sensitive

Continue Reading Bind Sensitive SQL May Also be Place Sensitive

Get index recommendations with SQL Optimizer for DB2 z/OS

Get index recommendations with SQL Optimizer for DB2 z/OS

Continue Reading Get index recommendations with SQL Optimizer for DB2 z/OS

SQL Rewrite to Twist Cost Estimation

SQL Rewrite to Twist Cost Estimation

Continue Reading SQL Rewrite to Twist Cost Estimation

Toad 12.1 Offers Major SQL Code Refactoring Capabilities

Toad 12.1 Offers Major SQL Code Refactoring Capabilities

Continue Reading Toad 12.1 Offers Major SQL Code Refactoring Capabilities

Test Running a Tuned SQL is Not An Easy Job

Test Running a Tuned SQL is Not An Easy Job

Continue Reading Test Running a Tuned SQL is Not An Easy Job

Shrinking Database Maintenance Windows With SQL Optimizer

Shrinking Database Maintenance Windows With SQL Optimizer

Continue Reading Shrinking Database Maintenance Windows With SQL Optimizer