Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance of view

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

Not what you were looking for? View more on this topic or Ask a question