In Open SQL statements such as Insert update delete which
one is FASTlLY retrieve the results and which one is Efficient?
- 4 Answers
- 10015 Views
- SAP Labs, I also Faced
- E-Mail Answers
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 |
Explain what are the different functions used in sap script?
What is match code? : sap abap hr
how can you make select options as a parameter?
What is the significance of delivery class? : abap data dictionary
what is the default event that is triggers in report?
9 Answers TCS, Unilogic Software, Unilogic Technologies,
What does a lock object involve?
What are the buffering types?
What is the difference between view and table ?
13 Answers Deloitte, Renault Nissan,
What is a table attribute?
how will u write a report for performance point of view ?
What are the different types of parameters? : abap modularization
if some one deleted your records from ztable how o u see the records?
-
SAP Basis (1262) - SAP ABAP (3939)
- SAPScript (236)
- SAP SD (Sales & Distribution) (2716)
- SAP MM (Material Management) (912)
- SAP QM (Quality Management) (99)
- SAP PP (Production Planning) (523)
- SAP PM (Plant Maintenance) (252)
- SAP PS (Project Systems) (138)
- SAP FI-CO (Financial Accounting & Controlling) (2766)
- SAP HR (Human Resource Management) (1180)
- SAP CRM (Customer Relationship Management) (432)
- SAP SRM (Supplier Relationship Management) (132)
- SAP APO (Advanced Planner Optimizer) (92)
- SAP BW (Business Warehouse) (896)
- SAP Business Workflow (72)
- SAP Security (597)
- SAP Interfaces (74)
- SAP Netweaver (282)
- SAP ALE IDocs (163)
- SAP Business One (110)
- SAP BO BOBJ (Business Objects) (388)
- SAP CPS (Central Process Scheduling) (14)
- SAP GTS (Global Trade Services) (21)
- SAP Hybris (132)
- SAP HANA (700)
- SAP PI (Process Integration) (113)
- SAP PO (Process Orchestration) (25)
- SAP BI (Business Intelligence) (174)
- SAP BPC (Business Planning and Consolidation) (38)
- SAP BODS (Business Objects Data Services) (49)
- SAP BODI (Business Objects Data Integrator) (26)
- SAP Ariba (9)
- SAP Fiori (45)
- SAP EWM (Extended Warehouse Management) (58)
- Sap R/3 (150)
- SAP FSCM Financial Supply Chain Management (101)
- SAP WM (Warehouse Management) (31)
- SAP GRC (Governance Risk and Compliance) (64)
- SAP MDM (Master Data Management) (0)
- SAP MRS (Multi Resource Scheduling) (0)
- SAP ESS MSS (Employee Manager Self Service) (13)
- SAP CS (Customer Service) (0)
- SAP TRM (Treasury and Risk Management) (0)
- SAP Web Dynpro ABAP (198)
- SAP IBP (Integrated Business Planning) (0)
- SAP OO-ABAP (Object Oriented ABAP) (70)
- SAP S/4 HANA Finance (Simple Finance) (143)
- SAP FS-CD (Collections and Disbursements) (0)
- SAP PLM (Product Lifecycle Management) (0)
- SAP SuccessFactors (33)
- SAP Vistex (0)
- SAP ISR (IS Retail) (28)
- SAP IdM (Identity Management) (0)
- SAP IM (Investment Management) (0)
- SAP UI5 (59)
- SAP SCM (Supply Chain Management) (51)
- SAP XI (Exchange Infrastructure) (49)
- SAP Cloud Platform (34)
- SAP Testing (89)
- SAP SolMan (Solution Manager) (63)
- SAP MaxDB (116)
- SAP GUI (15)
- SAP AllOther (329)
