Author: Richard To

How to speed up multiple aggregation functions apply to the same table

• Post author:By Richard To

How to speed up multiple aggregation functions apply to the same table

Tags: Oracle, SQL Optimizer, SQL Optimizer for Oracle

Bind Sensitive SQL May Also be Place Sensitive

• Post author:By Richard To

Bind Sensitive SQL May Also be Place Sensitive

Tags: SQL Optimizer for Oracle, SQL Optimizer for SQL Server

Real Workload Based Index Advisor Works on a Complex Environment – Toad Xpert SQL Optimizer

• Post author:By Richard To

Real Workload Based Index Advisor Works on a Complex Environment - Toad Xpert SQL Optimizer

Tags: Oracle, SQL Optimizer, Toad for Oracle

SQL Rewrite to Twist Cost Estimation

• Post author:By Richard To

SQL Rewrite to Twist Cost Estimation

Tags: Oracle, SQL Optimizer for Oracle

A New Test Run Wizard for SQL Optimizer for Oracle

• Post author:By Richard To

A New Test Run Wizard for SQL Optimizer for Oracle

Tags: Oracle, SQL Optimizer, SQL Optimizer for Oracle

Test Running a Tuned SQL is Not An Easy Job

• Post author:By Richard To

Test Running a Tuned SQL is Not An Easy Job

Tags: SQL Optimizer for SQL Server, SQL Server

Why Some SQL Tuning Rewrites are not always Correct ?

• Post author:By Richard To

Why Some SQL Tuning Rewrites are not always Correct ?

Tags: Oracle, SQL Optimizer, SQL Optimizer for Oracle, Toad for Oracle

100% Correct Cost Estimation Leads to the Best SQL Optimization – 10 Common Misconceptions in SQL Tuning #10

• Post author:By Richard To

100% Correct Cost Estimation Leads to the Best SQL Optimization - 10 Common Misconceptions in SQL Tuning #10

Tags: Oracle, SQL Optimizer, SQL Optimizer for Oracle

SQL Optimizer for Oracle – Optimize SQL (SQL Rewrite)

• Post author:By Richard To

Optimize SQL (SQL Rewrite)

Tags: SQL Optimizer for Oracle, Toad for Oracle, Tutorial, Wiki