📄 lojreorder.out
字号:
3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from t left outer join (s left outer join v8 on (f = cv)) on (d=a);A |B |C |D |E |F |CV |BV |AV -----------------------------------------------------------------------------------------------1 |1.000 |1 |NULL |NULL |NULL |1 |1.000 |1 2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from t left outer join (v1 left outer join s on (f = cv)) on (av=a);A |B |C |FV |EV |DV |CV |BV |AV |D |E |F -------------------------------------------------------------------------------------------------------------------------------1 |1.000 |1 |1 |1.000 |1 |NULL |NULL |NULL |NULL |NULL |NULL 2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from t left outer join (v8 left outer join s on (f = cv)) on (av=a);A |B |C |CV |BV |AV |D |E |F -----------------------------------------------------------------------------------------------1 |1.000 |1 |1 |1.000 |1 |NULL |NULL |NULL 2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> -- No LOJ reordering due to join conditionsselect * from v1 left outer join (s left outer join r on (f = i)) on (g=v1.av);FV |EV |DV |CV |BV |AV |D |E |F |G |H |I -------------------------------------------------------------------------------------------------------------------------------NULL |NULL |NULL |1 |1.000 |1 |NULL |NULL |NULL |NULL |NULL |NULL 2 |2.000 |2 |2 |2.000 |2 |NULL |NULL |NULL |NULL |NULL |NULL 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from v2 left outer join (s left outer join r on (f = i)) on (g=v2.av);FV |EV |DV |CV |BV |AV |D |E |F |G |H |I -------------------------------------------------------------------------------------------------------------------------------2 |2.000 |2 |2 |2.000 |2 |NULL |NULL |NULL |NULL |NULL |NULL 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from t left outer join (s left outer join v1 on (f = cv)) on (av=a);A |B |C |D |E |F |FV |EV |DV |CV |BV |AV -------------------------------------------------------------------------------------------------------------------------------1 |1.000 |1 |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL 2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from t left outer join (s left outer join v8 on (f = cv)) on (av=a);A |B |C |D |E |F |CV |BV |AV -----------------------------------------------------------------------------------------------1 |1.000 |1 |NULL |NULL |NULL |NULL |NULL |NULL 2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from t left outer join (v1 left outer join s on (f = cv)) on (d=a);A |B |C |FV |EV |DV |CV |BV |AV |D |E |F -------------------------------------------------------------------------------------------------------------------------------1 |1.000 |1 |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL 2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> select * from t left outer join (v8 left outer join s on (f = cv)) on (d=a);A |B |C |CV |BV |AV |D |E |F -----------------------------------------------------------------------------------------------1 |1.000 |1 |NULL |NULL |NULL |NULL |NULL |NULL 2 |2.000 |2 |2 |2.000 |2 |2 |2.000 |2 3 |3.000 |3 |3 |3.000 |3 |3 |3.000 |3 ij> -- values clause-- select * from table (values (1, 2, 3)) as q(a, b, c);drop view v1;0 rows inserted/updated/deletedij> drop view v2;0 rows inserted/updated/deletedij> drop view v3;0 rows inserted/updated/deletedij> drop view v4;0 rows inserted/updated/deletedij> drop view v5;0 rows inserted/updated/deletedij> drop view v6;0 rows inserted/updated/deletedij> drop view v7;0 rows inserted/updated/deletedij> drop view v8;0 rows inserted/updated/deletedij> drop view loj;0 rows inserted/updated/deletedij> drop view vv;0 rows inserted/updated/deletedij> drop view lojv;0 rows inserted/updated/deletedij> drop view jv;0 rows inserted/updated/deletedij> DROP TABLE T;0 rows inserted/updated/deletedij> DROP TABLE S;0 rows inserted/updated/deletedij> DROP TABLE R;0 rows inserted/updated/deletedij> DROP TABLE TT;0 rows inserted/updated/deletedij> -- from the customerCREATE TABLE TNL1 (ID INTEGER NOT NULL UNIQUE, col_char CHAR(20), col_decimal DECIMAL(12,5));0 rows inserted/updated/deletedij> insert into TNL1 values (1, 'abc', 1.1);1 row inserted/updated/deletedij> insert into TNL1 values (2, 'bcd', 2.2);1 row inserted/updated/deletedij> insert into TNL1 values (3, 'cde', 3.3);1 row inserted/updated/deletedij> insert into TNL1 values (4, 'ABC', 1.1);1 row inserted/updated/deletedij> insert into TNL1 values (5, 'BCD', 2.2);1 row inserted/updated/deletedij> insert into TNL1 values (6, 'CDE', 3.3);1 row inserted/updated/deletedij> CREATE TABLE TNL1_1 (ID INTEGER NOT NULL UNIQUE, col_char CHAR(20), col_decimal DECIMAL(12,5), ID2 INTEGER);0 rows inserted/updated/deletedij> CREATE INDEX I_TNL11 ON TNL1_1 (ID2 ASC);0 rows inserted/updated/deletedij> insert into TNL1_1 values (3, 'cde', 3.3, 30);1 row inserted/updated/deletedij> insert into TNL1_1 values (4, 'xyz', 4.4, 40);1 row inserted/updated/deletedij> insert into TNL1_1 values (5, 'lmn', 5.5, 50);1 row inserted/updated/deletedij> insert into TNL1_1 values (6, 'CDE', 3.3, 30);1 row inserted/updated/deletedij> insert into TNL1_1 values (7, 'XYZ', 4.4, 40);1 row inserted/updated/deletedij> insert into TNL1_1 values (8, 'LMN', 5.5, 50);1 row inserted/updated/deletedij> CREATE TABLE TNL1_1_1 (ID INTEGER NOT NULL UNIQUE, col_char CHAR(20), col_decimal DECIMAL(12,5));0 rows inserted/updated/deletedij> insert into TNL1_1_1 values (2, 'bcd', 2.2);1 row inserted/updated/deletedij> insert into TNL1_1_1 values (3, 'cde', 3.3);1 row inserted/updated/deletedij> insert into TNL1_1_1 values (4, 'xyz', 4.4);1 row inserted/updated/deletedij> insert into TNL1_1_1 values (5, 'BCD', 2.2);1 row inserted/updated/deletedij> insert into TNL1_1_1 values (6, 'CDE', 3.3);1 row inserted/updated/deletedij> insert into TNL1_1_1 values (7, 'XYZ', 4.4);1 row inserted/updated/deletedij> CREATE TABLE TNL1_2 (ID INTEGER NOT NULL UNIQUE, col_char CHAR(20), col_decimal DECIMAL(12,5));0 rows inserted/updated/deletedij> insert into TNL1_2 values (4, 'xyz', 4.4);1 row inserted/updated/deletedij> insert into TNL1_2 values (5, 'lmn', 5.5);1 row inserted/updated/deletedij> insert into TNL1_2 values (6, 'stu', 6.6);1 row inserted/updated/deletedij> insert into TNL1_2 values (7, 'XYZ', 4.4);1 row inserted/updated/deletedij> insert into TNL1_2 values (8, 'LMN', 5.5);1 row inserted/updated/deletedij> insert into TNL1_2 values (9, 'STU', 6.6);1 row inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);0 rows inserted/updated/deletedij> maximumdisplaywidth 8000;ij> SELECT * FROM TNL1 A LEFT OUTER JOIN TNL1_1 B ON A.ID = B.ID LEFT OUTER JOIN TNL1_1_1 C ON B.ID2=C.ID LEFT OUTER JOIN TNL1_2 D ON A.ID=D.ID ORDER BY 1;ID |COL_CHAR |COL_DECIMAL |ID |COL_CHAR |COL_DECIMAL |ID2 |ID |COL_CHAR |COL_DECIMAL |ID |COL_CHAR |COL_DECIMAL ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1 |abc |1.10000 |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL 2 |bcd |2.20000 |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL 3 |cde |3.30000 |3 |cde |3.30000 |30 |NULL |NULL |NULL |NULL |NULL |NULL 4 |ABC ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -