Toad World Blog

Richard To

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

Richard To

sqlNavOracle

Oracle

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

I have heard a lot of people ask  "Why my SQL performance is vary depending on where ... Keep reading >
oraclePlatform

Toad for Oracle

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: Toad for Oracle Oracle SQL Optimizer 0 Comments
sqlNavOracle

Oracle

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: Oracle SQL Optimizer for Oracle 0 Comments

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 Server

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 Server SQL Optimizer for SQL Server 0 Comments
oraclePlatform

Toad for Oracle

A junior developer came to me recently and asked me a SQL transformation question. ... Keep reading >
oraclePlatform

Oracle

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

Toad for Oracle

Using SQL Rewrite mode in Optimize SQL consists of two steps. In the first step, SQL ... Keep reading >