Wednesday, April 02, 2008

Toad World > Community > Quest Experts' Blogs - How to use the Quest SQL Optimizer

Toad World - Community - Quest Experts' Blogs - How to use the Quest SQL Optimizer: "Quest SQL Optimizer can do an extensive transformation of the syntax of a SQL statement while still maintaining the exact same result set. This exhaustive transformation can produce hundreds of SQL alternatives. So it is necessary to have some insight as how to find a SQL alternative that is better than your original SQL statement without spending too much time. This is especially true when you have a SQL statement with complicated syntax."