blob: b84836074609dd823fa1828d7ae5bb73af613159 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
use plato;
pragma warning("disable", "8001"); -- CBO_MISSING_TABLE_STATS
pragma CostBasedOptimizer="pg";
select i1.value, i2.value, i3.value, i4.value
from Input1 as i1
join Input2 as i2 on i1.key=i2.key
join Input3 as i3 on i1.key=i3.key
join Input4 as i4 on i1.key=i4.key
order by i1.value, i2.value, i3.value, i4.value;
|
