Database
sql.txt
Associated article: External SQL Rewriters
Tags: Database
Published source code accompanying the article by Richard To and Cara Pang in which they present techniques for optimizing SQL statements by generating alternative execution plans to find the one with the least estimated cost.
External SQL Rewriters
by Richard To and Cara Pang
Listing One
SELECT *
FROM A
WHERE A.C1 IN (SELECT B.C1
FROM B
WHERE EXISTS (SELECT 'x'
FROM C
WHERE B.C2 = C.C2 ))
Listing Two
SELECT *
FROM grade A
...
