| Bad performance in complex que due to bad sql ? [message #25880] |
Thu, 22 May 2003 09:10  |
Masse
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
Hi !
I´ve problem vith performance in a rather complex sql-statement. Is it deppending on bad sql or what ? I suppose there is lots of alternative code. Anyone ?
SELECT P.COL1,
P.COL2,
P.COL3,
A.COL1,
A.COL2,
A.COL3,
S1.COL1 ||'-'|| S2.COL1||' '||S3.COL2 ALIAS1,
S4.COL1 ||'-'|| S5.COL1||' '||S6.COL2 ALIAS2,
S7.COL1 ||'-'|| S8.COL1||' '||S9.COL2 ALIAS3,
P.COL4 || ' ' || P.COL5 || P.COL6 ALIAS4
FROM TABLE_P P,
TABLE_A A,
TABLE_O O,
TABLE_S S1,
TABLE_S S2,
TABLE_S S3,
TABLE_S S4,
TABLE_S S5,
TABLE_S S6,
TABLE_S S7,
TABLE_S S8,
TABLE_S S9
WHERE A.COL1(+) = P.COL1
AND O.COL1 = P.COL4
And O.COL2 = P.COL5
And O.COL3 = S1.COL3(+)
And O.COL3 = S2.COL3(+)
And O.COL3 = S3.COL3(+)
And O.COL3 = S4.COL3(+)
And O.COL3 = S5.COL3(+)
And O.COL3 = S6.COL3(+)
And O.COL3 = S7.COL3(+)
And O.COL3 = S8.COL3(+)
And O.COL3 = S9.COL3(+)
AND P.COL6=(SELECT TABLE_P.COL7 FROM TABLE_P WHERE TABLE_P.COL8 = :PARAM1)
AND S1.COL4(+) = 'VALUE1'
AND S2.COL4(+) = 'VALUE2'
AND S3.COL4(+) = 'VALUE3'
AND S4.COL4(+) = 'VALUE4'
AND S5.COL4(+) = 'VALUE5'
AND S6.COL4(+) = 'VALUE6'
AND S7.COL4(+) = 'VALUE7'
AND S8.COL4(+) = 'VALUE8'
AND S9.COL4(+) = 'VALUE9'
Help.......
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
