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 |
What are logical databases? What are the advantages of logical databases?
In BDC,i have 3 transaction and one flat file with data for all those 3 transaction requires........i want to process these 3 transaction at a time using that single flat file,if 3rd transaction fails to upload the record,can we roll back the remaining 2 transaction or we can't?Is it possible in BDC,How?
Difference between Read and Get cursor?
How to create user interfaces for lists?
What is modularization and its benefits? : abap modularization
What is the difference between value table and check table?
4 Answers Accenture, TechCatalyst,
HOW MANY WAYS TO DEFINE INTERNAL TABLES.
In start of selection, if we perform validation, what happens ?
Why do we use abstract class
What are the requirements a dialog program must fulfill?
what is the variable to be used in sap scripts to find the total number of pages of the print job?
Explain how data is stored in cluster table?