Select query optimisation
Answer / Aadesh Kumar
Select query optimization in SAP ABAP can involve various techniques like:<br><br>1. Using appropriate indexes on tables involved in the query.<br>2. Avoiding unnecessary joins or reducing the number of joins by using UNION ALL instead of SELECT DISTINCT.<br>3. Avoiding subqueries if possible, and using inline views when necessary.<br>4. Optimizing where clauses by minimizing the number of conditions and using appropriate operators.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the impact of issuing of worning message inside the event of start of selection?
What is the mandatory event in LDBs.
What is the difference between field-group header and other field groups?
GUYS any one please can u post questions in sap a bap webdynpro questions.. please i need to know some technical questions regarding webdynpro and ADOBE forms ?
Elements of Main window and is Main window compulsory in Sap script ?
Define dispatcher?
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
What are the different message types available in the abap/4 ?
In Badi wher is the standard prograam name to add the additional progaram
WHICH LANGUAGE IS USED TO WRITE ABAP CODING PART?
What do you do when the system crashes in the middle of batch session?
We execute the BDC program in foreground and got list in C drive. If the same program we can execute in back ground what happen?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (916)
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 APO PPDS (49)
SAP AllOther (329)