Toad World Blog

Richard To

Richard specializes in using AI technique to solve database performance problems.

Richard To

sqlNavOracle

Oracle

How to speed up multiple aggregation functions apply to the ...
If you want to find the minimum salary among all employees, you may issue a SQL ... Keep reading >
Posted on Jun 11, 2015 12:27:02 AM by Richard To
Tags: Oracle SQL Optimizer SQL Optimizer for Oracle 0 Comments
sqlNavOracle

SQL Optimizer for Oracle

Bind Sensitive SQL May Also be Place Sensitive
I have heard a lot of people ask  "Why my SQL performance is vary depending on where ... Keep reading >
Posted on Apr 22, 2015 11:51:56 PM by Richard To
Tags: SQL Optimizer for Oracle SQL Optimizer for SQL Server 0 Comments
oraclePlatform

Oracle

Real Workload Based Index Advisor Works on a Complex ...
Here is part of a case study that I would like to share with our users: Keep reading >
Posted on Feb 2, 2015 4:01:00 AM by Richard To
Tags: Oracle SQL Optimizer Toad for Oracle 0 Comments
sqlNavOracle

SQL Optimizer for Oracle

SQL Rewrite to Twist Cost Estimation
There are mainly three problems that database SQL optimizer cannot find the best way ... Keep reading >
Posted on Oct 22, 2014 2:58:49 AM by Richard To
Tags: SQL Optimizer for Oracle Oracle 0 Comments

Oracle

A New Test Run Wizard for SQL Optimizer for Oracle
In SQL Optimizer for SQL Server we have built a very useful test run wizard (see my ... Keep reading >
Posted on Sep 15, 2014 3:00:00 AM by Richard To
Tags: Oracle SQL Optimizer SQL Optimizer for Oracle 0 Comments
sqlNavSQL

SQL Optimizer for SQL Server

Test Running a Tuned SQL is Not An Easy Job
In SQL Optimizer for SQL Server, we have built a very sophisticated test run ... Keep reading >
Posted on Jun 5, 2014 11:18:00 PM by Richard To
Tags: SQL Optimizer for SQL Server SQL Server 0 Comments
oraclePlatform

Oracle

Why Some SQL Tuning Rewrites are not always Correct ?
A junior developer came to me recently and asked me a SQL transformation question. ... Keep reading >
Posted on Apr 10, 2014 9:39:00 PM by Richard To
Tags: Oracle SQL Optimizer SQL Optimizer for Oracle Toad for Oracle 0 Comments
oraclePlatform

Oracle

100% Correct Cost Estimation Leads to the Best SQL ...
This blog is the finale in this series about common misconceptions surrounding SQL ... Keep reading >
Posted on Mar 4, 2014 9:40:14 PM by Richard To
Tags: Oracle SQL Optimizer SQL Optimizer for Oracle 0 Comments
sqlNavOracle

SQL Optimizer for Oracle

SQL Optimizer for Oracle - Optimize SQL (SQL Rewrite)
Using SQL Rewrite mode in Optimize SQL consists of two steps. In the first step, SQL ... Keep reading >
Posted on Jan 11, 2013 1:13:00 PM by Richard To
Tags: SQL Optimizer for Oracle Toad for Oracle Tutorial Wiki 0 Comments