Skip to Content

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

view vs table wich select is faster?

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.-

Helpful Answer

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