which of the following is more efficient when we are
retrieving data from more tables.
select statement using innerjoins or select statement using
for all entries?
- 9 Answers
- 10608 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / joydip
One Single Inner join between database tables is much
faster than multiple For all entries.Also we may have to
create more internal tables in ABAP code to avoid one inner
join, which is not referable.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is an abap?
What are two different ways to add fields to sap tables?
Explain about interactive report?
Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?
What happens when you post goods issue after delivery? How does the inventory get reduced after the delivery?
WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA
What are the attributes of a field that can be activated or deactivated during runtime?
How do you activate a function exit?
How will you transfer data into a file in application server?
Explain the concept of clusters in payroll
What is search help exit? : sap abap data dictionary
How we can retrieve data using secondary index. Explain with simple example?
What are the different functions used in sap script? What are the parameters used in each function?
What is an abap instance?
What is the meaning of abap editor integrated with abap data dictionary? : abap data dictionary
