09-24-2008 12:42 PM
I have created a database view on 7 tables. Given below is the query for view creation.taken from SE11 . Can we improve upon the performance by changing this query for view creation .
CREATE VIEW "ZUSER_ADDRS"
("MANDT",
"BNAME",
"NAME_LAST",
"NAME_FIRST",
"NAME_TEXT",
"FUNCTION",
"DEPARTMENT",
"TEL_NUMBER",
"TEL_EXTENS",
"FAX_NUMBER",
"BUILDING",
"ROOMNUMBER",
"NAME1",
"USREFUS",
"CLASS",
"UFLAG",
"KOSTL",
"LANGU",
"PERSNUMBER",
"ADDRNUMBER")
AS SELECT
T1."MANDT",
T1."BNAME",
T2."NAME_LAST",
T2."NAME_FIRST",
T2."NAME_TEXT",
T3."FUNCTION",
T3."DEPARTMENT",
T3."TEL_NUMBER",
T3."TEL_EXTENS",
T3."FAX_NUMBER",
T3."BUILDING",
T3."ROOMNUMBER",
T4."NAME1",
T5."USERALIAS",
T6."CLASS",
T6."UFLAG",
T1."KOSTL",
T7."LANGU",
T1."PERSNUMBER",
T1."ADDRNUMBER"
FROM
"USR21" T1,
"ADRP" T2,
"ADCP" T3,
"ADRC" T4,
"USREFUS" T5,
"USR02" T6,
"USR01" T7
WHERE
T2."CLIENT" = T3."CLIENT" AND
T2."PERSNUMBER" = T3."PERSNUMBER" AND
T2."NATION" = T3."NATION" AND
T2."PERSNUMBER" = T1."PERSNUMBER" AND
T4."CLIENT" = T3."CLIENT" AND
T4."ADDRNUMBER" = T3."ADDRNUMBER" AND
T4."NATION" = T3."NATION" AND
T4."ADDRNUMBER" = T1."ADDRNUMBER" AND
T2."CLIENT" = T1."MANDT" AND
T1."MANDT" = T6."MANDT" AND
T1."BNAME" = T6."BNAME" AND
T6."MANDT" = T5."MANDT" AND
T6."BNAME" = T5."BNAME" AND
T7."MANDT" = T5."MANDT" AND
T7."BNAME" = T5."BNAME" AND
T6."BNAME" = T1."BNAME"
AND
T2."DATE_FROM"
= '00010101' AND
T2."NATION"
= ' ' AND
T2."PERS_GROUP"
= 'BC01' AND
T4."DATE_FROM"
= '00010101' AND
T4."NATION"
= ' ' AND
T3."DATE_FROM"
= '00010101' AND
T3."NATION"
= ' '
Please help me in this regard
09-24-2008 1:10 PM
Use the select statement and perform SQL trace that should help you .
[https://forums.sdn.sap.com/click.jspa?searchID=16688114&messageID=5843803|https://forums.sdn.sap.com/click.jspa?searchID=16688114&messageID=5843803]
Edited by: Arun Thiyagarajan on Sep 24, 2008 5:42 PM