blob: d59f5f6bdc280e9bf169b7b6e678bfa5ec54e10e (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
|
use plato;
pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
pragma CostBasedOptimizer="PG";
pragma yt.OptimizeFor="scan";
select i1.value, i2.value
from Input1 as i1
left join Input2 as i2 on i1.key=i2.key
order by i1.value, i2.value;
|