In Open SQL statements such as Insert update delete which
one is FASTlLY retrieve the results and which one is Efficient?
Answers were Sorted based on User's Feedback
Answer / sivaramakrishna
hai mr venkata satish it's vary simple
create one pg . and use these open sql statements for
operations on a custom ztable.
st05 is the tcode to identify that which opensql st taking
how much time for excution i.e called performence tunig.
now u will get the answre.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / theabapconsultant
update is the statement which will retrieve faastly. and efficent as well.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ank
in my opinion, Insert fastly retrieve the results and
update is efficient.
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / ramu
In My Openion Delete option can show the faster results than other SQL Statements.
Is This Answer Correct ? | 4 Yes | 4 No |
Type groups?
What is roles and responsibilities of sap hr consultants? : sap abap hr
how to transport query?
I have 10 records in flat file. In that 7th record is error record. I want to update to data base. If i used Call transaction method what about 7 record and what about 8,9,10 records. If i used Session method what happen. Is it updated or stop at 7th record?
After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then?
performance tuning concepts
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
SAP Date Format?
Which method is faster among 4 methods used in LSMW.?
Explain the properties of selection screen?
What are the Various Types of internal tables?
how top handle error in LSMW?