*   *ID* INVEXP1  DBCMD    changed on 1992-09-28-13.23.56 by ADMIN     *
explain select distinct &1 uk1 &2 from u &3!
explain select distinct &1 uk2 &2 from u &3!
explain select distinct &1 uk3 &2 from u &3!
explain select distinct &1 uk1,uk2 &2 from u &3!
explain select distinct &1 uk1,uk2,uk3 &2 from u &3!
explain select distinct &1 u1 &2 from u &3!
explain select distinct &1 u2 &2 from u &3!
explain select distinct &1 u3 &2 from u &3!
explain select distinct &1 u4 &2 from u &3!
explain select distinct &1 u5 &2 from u &3!
explain select distinct &1 u6 &2 from u &3!
explain select distinct &1 u1,uk1 &2 from u &3!
explain select distinct &1 u1,uk2 &2 from u &3!
explain select distinct &1 u1,uk3 &2 from u &3!
explain select distinct &1 u2,uk1 &2 from u &3!
explain select distinct &1 u2,uk2 &2 from u &3!
explain select distinct &1 u2,uk3 &2 from u &3!
explain select distinct &1 u3,uk1 &2 from u &3!
explain select distinct &1 u3,uk2 &2 from u &3!
explain select distinct &1 u3,uk3 &2 from u &3!
explain select distinct &1 u4,uk1 &2 from u &3!
explain select distinct &1 u4,uk2 &2 from u &3!
explain select distinct &1 u4,uk3 &2 from u &3!
explain select distinct &1 u5,uk1 &2 from u &3!
explain select distinct &1 u5,uk2 &2 from u &3!
explain select distinct &1 u5,uk3 &2 from u &3!
explain select distinct &1 u6,uk1 &2 from u &3!
explain select distinct &1 u6,uk2 &2 from u &3!
explain select distinct &1 u6,uk3 &2 from u &3!
explain select distinct &1 uk1,u1 &2 from u &3!
explain select distinct &1 uk2,u1 &2 from u &3!
explain select distinct &1 uk3,u1 &2 from u &3!
explain select distinct &1 uk1,u2 &2 from u &3!
explain select distinct &1 uk2,u2 &2 from u &3!
explain select distinct &1 uk3,u2 &2 from u &3!
explain select distinct &1 uk1,u3 &2 from u &3!
explain select distinct &1 uk2,u3 &2 from u &3!
explain select distinct &1 uk3,u3 &2 from u &3!
explain select distinct &1 uk1,u4 &2 from u &3!
explain select distinct &1 uk2,u4 &2 from u &3!
explain select distinct &1 uk3,u4 &2 from u &3!
explain select distinct &1 uk1,u5 &2 from u &3!
explain select distinct &1 uk2,u5 &2 from u &3!
explain select distinct &1 uk3,u5 &2 from u &3!
explain select distinct &1 uk1,u6 &2 from u &3!
explain select distinct &1 uk2,u6 &2 from u &3!
explain select distinct &1 uk3,u6 &2 from u &3!
explain select distinct &1 u1,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1,u1 &2 from u &3!
explain select distinct &1 u1,uk1,uk3 &2 from u &3!
explain select distinct &1 uk3,uk1,u1 &2 from u &3!
explain select distinct &1 u1,uk3,uk2 &2 from u &3!
explain select distinct &1 uk2,uk3,u1 &2 from u &3!
explain select distinct &1 u2,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1,u2 &2 from u &3!
explain select distinct &1 u2,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,u2 &2 from u &3!
explain select distinct &1 u2,uk3,uk2 &2 from u &3!
explain select distinct &1 uk2,uk3,u2 &2 from u &3!
explain select distinct &1 u3,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1,u3 &2 from u &3!
explain select distinct &1 u3,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,u3 &2 from u &3!
explain select distinct &1 u4,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1,u4 &2 from u &3!
explain select distinct &1 u4,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,u4 &2 from u &3!
explain select distinct &1 u4,uk3,uk2 &2 from u &3!
explain select distinct &1 uk2,uk3,u4 &2 from u &3!
explain select distinct &1 u5,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1,u5 &2 from u &3!
explain select distinct &1 u5,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,u5 &2 from u &3!
explain select distinct &1 u5,uk3,uk2 &2 from u &3!
explain select distinct &1 uk2,uk3,u5 &2 from u &3!
explain select distinct &1 u6,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1,u6 &2 from u &3!
explain select distinct &1 u6,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,u6 &2 from u &3!
explain select distinct &1 u6,uk3,uk2 &2 from u &3!
explain select distinct &1 uk2,uk3,u6 &2 from u &3!
explain select distinct &1 uk3,u1,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1,u1,uk3 &2 from u &3!
explain select distinct &1 uk2,u1,uk1,uk3 &2 from u &3!
explain select distinct &1 uk3,uk1,u1,uk2 &2 from u &3!
explain select distinct &1 u1,uk3,uk2,uk1 &2 from u &3!
explain select distinct &1 uk1,uk2,uk3,u1 &2 from u &3!
explain select distinct &1 u2,uk1,uk2,uk3 &2 from u &3!
explain select distinct &1 uk2,uk1,u2,uk3 &2 from u &3!
explain select distinct &1 uk2,u2,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,u2,uk2 &2 from u &3!
explain select distinct &1 u2,uk3,uk2,uk1 &2 from u &3!
explain select distinct &1 uk1,uk2,uk3,u2 &2 from u &3!
explain select distinct &1 uk3,u3,uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk3,uk1,u3 &2 from u &3!
explain select distinct &1 u3,uk2,uk3,uk1 &2 from u &3!
explain select distinct &1 uk2,uk1,uk3,u3 &2 from u &3!
explain select distinct &1 u4,uk1,uk2,uk3 &2 from u &3!
explain select distinct &1 uk2,uk1,u4,uk3 &2 from u &3!
explain select distinct &1 uk2,u4,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,u4,uk2 &2 from u &3!
explain select distinct &1 uk1,u4,uk3,uk2 &2 from u &3!
explain select distinct &1 uk2,uk3,u4,uk1 &2 from u &3!
explain select distinct &1 u5,uk1,uk3,uk2 &2 from u &3!
explain select distinct &1 uk3,uk2,uk1,u5 &2 from u &3!
explain select distinct &1 uk2,u5,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk2,uk3,u5 &2 from u &3!
explain select distinct &1 u5,uk3,uk2,uk1 &2 from u &3!
explain select distinct &1 uk2,uk3,u5,uk1 &2 from u &3!
explain select distinct &1 u6,uk1,uk2,uk3 &2 from u &3!
explain select distinct &1 uk2,uk1,u6,uk3 &2 from u &3!
explain select distinct &1 u6,uk3,uk1,uk2 &2 from u &3!
explain select distinct &1 uk1,uk3,u6,uk2 &2 from u &3!
explain select distinct &1 u6,uk3,uk2,uk1 &2 from u &3!
explain select distinct &1 uk2,uk3,u6,uk1 &2 from u &3!
commit!
explain select distinct &1 u1 &2 from u order by u1 &3!
explain select distinct &1 u2 &2 from u order by u2 &3!
explain select distinct &1 u3 &2 from u order by u3 &3!
explain select distinct &1 u4 &2 from u order by u4 &3!
explain select distinct &1 u5 &2 from u order by u5 &3!
explain select distinct &1 u6 &2 from u order by u6 &3!
explain select distinct &1 u1 &2 from u where u1 = 'Z' &3!
explain select distinct &1 u1 &2 from u where u1 like 'Z' &3!
explain select distinct &1 u2 &2 from u where u2 in (9,7,5,3,1,0) &3!
explain select distinct &1 u2 &2 from u where u2 between 0 and 9 &3!
explain select distinct &1 u3 &2 from u where u3 > 'A' &3!
explain select distinct &1 u3 &2 from u 
where u3 > ' ' AND u3 < 'ZZ' &3!
explain select distinct &1 u4 &2 from u where u4 < 1000 &3!
explain select distinct &1 u4 &2 from u where u4 > 1000 &3!
explain select distinct &1 u5 &2 from u where u5 is null &3!
explain select distinct &1 u5 &2 from u where u5 is not null &3!
explain select distinct &1 u6 &2 from u where u6 like 'Z%' &3!
explain select distinct &1 u6 &2 from u where u6 like '%Z' &3!
explain select distinct &1 u1 &2 from u where u1 = 'Z' 
order by u1 &3!
explain select distinct &1 u1 &2 from u where u1 like 'Z' 
order by u1 &3!
explain select distinct &1 u2 &2 from u where u2 in (9,7,5,3,1,0) 
order by u2 &3!
explain select distinct &1 u2 &2 from u where u2 between 0 and 9 
order by u2 &3!
explain select distinct &1 u3 &2 from u where u3 > 'A' 
order by u3 &3!
explain select distinct &1 u3 &2 from u where u3 > ' ' AND u3 < 'ZZ' 
order by u3 &3!
explain select distinct &1 u4 &2 from u where u4 < 1000 
order by u4 &3!
explain select distinct &1 u4 &2 from u where u4 > 1000 
order by u4 &3!
explain select distinct &1 u5 &2 from u where u5 is null 
order by u5 &3!
explain select distinct &1 u5 &2 from u where u5 is not null 
order by u5 &3!
explain select distinct &1 u6 &2 from u where u6 like 'Z%' 
order by u6 &3!
explain select distinct &1 u6 &2 from u where u6 like '%Z' 
order by u6 &3!
commit!
explain select distinct &1 u1,uk1 &2 from u order by u1 &3!
explain select distinct &1 u1,uk2 &2 from u 
where u1 in ('Z', 'A') AND uk2 > 0 &3!
explain select distinct &1 u1,uk3 &2 from u 
where u1 = 'A' AND uk3 = 'A' &3!
explain select distinct &1 u2,uk1 &2 from u order by uk1 &3!
explain select distinct &1 u2,uk2 &2 from u order by u2 &3!
explain select distinct &1 u2,uk3 &2 from u 
where u2 < 100 &3!
explain select distinct &1 u3,uk1 &2 from u 
where u3 like '%' &3!
explain select distinct &1 u3,uk2 &2 from u 
where uk2 < 100 &3!
explain select distinct &1 u3,uk3 &2 from u 
where u3 between 'A' AND 'C' AND uk3 between 'A' AND 'C' &3!
explain select distinct &1 u4,uk1 &2 from u order by u4,uk1 &3!
explain select distinct &1 u4,uk2 &2 from u 
where u4 in (1,12,123,1234,12340) &3!
explain select distinct &1 u4,uk3 &2 from u 
where u4 < 10 AND uk3 > 'A' &3!
explain select distinct &1 u5,uk1 &2 from u 
where u5 < 1000 &3!
explain select distinct &1 u5,uk2 &2 from u 
where u5 < 100 &3!
explain select distinct &1 u5,uk3 &2 from u 
where uk3 < 'C' &3!
explain select distinct &1 u6,uk1 &2 from u order by uk1,u6 &3!
explain select distinct &1 u6,uk2 &2 from u 
where u6 like 'A%A' AND uk2 in (1,0) &3!
explain select distinct &1 u6,uk3 &2 from u 
where u6 like '%A%' AND uk3 < 'D' &3!
explain select distinct &1 uk1,u1 &2 from u 
where uk2 > 0 &3!
explain select distinct &1 uk2,u1 &2 from u 
where uk3 in ('C','A','B') &3!
explain select distinct &1 uk3,u1 &2 from u 
where uk1 between 'A' AND 'Z' &3!
explain select distinct &1 uk1,u2 &2 from u 
where uk2 > 8 &3!
explain select distinct &1 uk1,u3 &2 from u 
where uk2 > 9 &3!
explain select distinct &1 uk1,u4 &2 from u 
where u4 < value(uk2,1)/value(u4,1) &3!
explain select distinct &1 uk1,u5 &2 from u 
where u5 is null order by u5 &3!
explain select distinct &1 uk2,u5 &2 from u 
where u5 is not null order by u5 &3!
explain select distinct &1 uk1,u6 &2 from u 
where u6 <> 'MMM' &3!
explain select distinct &1 uk2,u6 &2 from u 
where u6 like 'A%%%%%%A' &3!
explain select distinct &1 uk3,u6 &2 from u 
where uk1 > '0' and uk2 > 0 &3!
commit!
explain select distinct &1 substr(u1,1),uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,substr(uk1,1),u1 &2 from u &3!
explain select distinct &1 u1,uk1,uk3 &2 from u 
where uk2 = 9 &3!
explain select distinct &1 uk3,uk1,u1 &2 from u 
where uk2 = 0 &3!
explain select distinct &1 u1,uk3,uk2 &2 from u order by u1 &3!
explain select distinct &1 uk2,uk3,u1 &2 from u order by u1,uk2 &3!
explain select distinct &1 u2,uk1,uk2 &2 from u 
where u2 < 10 and uk1 = 'Z' and uk2 in (0,5,9) &3!
explain select distinct &1 uk2,uk1,u2*10 &2 from u 
where u2 between 0 AND 9 &3!
explain select distinct &1 u2/10,uk3,uk1 &2 from u 
where u2 >= 0 &3!
explain select distinct &1 uk1&uk3,u2 &2 from u 
where u2 <= 9 &3!
explain select distinct &1 u2,uk3,chr(uk2) &2 from u 
where u2 = 0 &3!
explain select distinct &1 uk2,uk3,chr(u2) &2 from u 
where u2 = 9 &3!
explain select distinct &1 u4+uk2,uk1 &2 from u &3!
explain select distinct &1 uk1,uk2-u4 &2 from u &3!
explain select distinct &1 substr(u6,1,1)&uk1,uk2 &2 from u &3!
explain select distinct &1 uk2,uk1&u6 &2 from u order by 2 &3!
explain select distinct &1 uk3&u1&uk1,uk2 &2 from u &3!
explain select distinct &1 chr(uk2)&uk1&u1&uk3 &2 from u &3!
explain select distinct &1 uk2,u1,uk1,uk3 &2 from u 
where u1 = uk1 &3!
explain select distinct &1 uk3,uk1,u1,uk2 &2 from u 
where u1 < uk1 &3!
explain select distinct &1 u1,uk3,uk2,uk1 &2 from u 
where uk1 = uk3 &3!
explain select distinct &1 uk1,uk2,uk3,u1 &2 from u 
where u1 not in ('Z', 'M', 'A') &3!
explain select distinct &1 u4*u4,uk1,uk2,uk3 &2 from u &3!
explain select distinct &1 uk2/uk2,uk1,u4,uk3 &2 from u &3!
explain select distinct &1 uk2*u4,uk3,uk1 &2 from u &3!
explain select distinct &1 uk1,uk3,trunc(u4,0) div uk2 &2 from u &3!
explain select distinct &1 uk1,trunc(u4,0) mod uk2,uk3 &2 from u &3!
explain select distinct &1 uk2,uk3,u4*1,uk1 &2 from u &3!
explain select distinct &1 u5,uk3,uk2,uk1 &2 from u 
where u5 is null &3!
explain select distinct &1 uk2,uk3,u5,uk1 &2 from u 
where u5 is not null &3!
explain select distinct &1 u6&uk1,uk2,uk3 &2 from u 
where u6 between 'AAA' AND 'ZZZ' &3!
explain select distinct &1 uk2,uk1,u6,uk3 &2 from u 
where uk3 < 'D' AND uk2 = 0 and uk1 = 'A' &3!
explain select distinct &1 u6,uk3,uk1,uk2 &2 from u 
where uk3 = 'A' and uk1 = 'Z' and uk2 = 0 &3!
explain select distinct &1 uk1,uk3,u6,uk2 &2 from u 
where uk3 = 'A' and uk1 = 'Z' and uk2 = 0 and u6 = 'ZZZ' &3!
explain select distinct &1 u6,uk3,uk2,uk1 &2 from u 
where u6 > '   ' and uk1 = 'A' &3!
explain select distinct &1 uk2,uk3,u6&uk1 &2 from u
where u6 > '   ' and uk1 = 'A' &3!
