Whenever we use open SQL statements to get fetch data in SAP,it will get data from buffer area(depends on table buffer settings) for better performance, but in real world scenarios some tables may updated very frequently.
we may need to bypass buffer to get real-time data, in that case we will bypass buffer using 'BYPASSING BUFFER' keyword.
Now fetching records directly from database may take time. Hence performance will go down. That’s why SQL fetches data from buffer.
Example :
Output:
No comments:
Post a Comment