How to avoid creation of view in remote DB?
Hi,
I have a query like this:
SELECT Column_1, Column_2, Column_3, ... in total 463 columns FROM SUMDB.F_CELLPI0_RNCCELL_DH@prs t1 JOIN SUMDB.F_CELLPI1_RNCCELL_DH@prs t2 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_CELLPI2_RNCCELL_DH@prs t3 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_CELLPI3_RNCCELL_DH@prs t4 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_CELLPI4_RNCCELL_DH@prs t5 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_CELLPI5_RNCCELL_DH@prs t6 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_CELLPI6_RNCCELL_DH@prs t7 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_CELLPI7_RNCCELL_DH@prs t8 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_TNN000005_RNCCELL_DH@prs t9 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_TNN000009_RNCCELL_DH@prs t10 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_TNN000043_RNCCELL_DH@prs t11 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) JOIN SUMDB.F_TNN000144_RNCCELL_DH@prs t12 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) LEFT OUTER JOIN SUMDB.F_NBCELLPI0_RNCCELL_DH@prs t13 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) LEFT OUTER JOIN SUMDB.F_TNN000161_RNCCELL_DH@prs t14 USING (RNCCELLID,STARTTIME,HOUR,DSTOFFSET,RULEID) WHERE STARTTIME = DATE '2015-09-24' AND RULEID = 100005;
0