Hello,
Im improving performance on a select stm.
I found out that the table Im using has a view.
Which select statement is faster??
SELECT SINGLE matnr charg
INTO (g_matnr, g_charg)
FROM V_MM_CHVW "view
WHERE werks = '2472'
AND ( bwart = '321'
OR bwart = '309'
OR bwart = '311'
OR bwart = 'Z09' )
AND umwrk = '2472'
AND ummat = i_lotes-matnr
AND umcha = i_lotes-charg.
or
SELECT SINGLE matnr charg
INTO (g_matnr, g_charg)
FROM CHVW " table used by the view
WHERE werks = '2472'
AND ( bwart = '321'
OR bwart = '309'
OR bwart = '311'
OR bwart = 'Z09' )
AND umwrk = '2472'
AND ummat = i_lotes-matnr
AND umcha = i_lotes-charg.
What do you think?
Bye
Gabriel P.-