Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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?

Answer Posted / prats

For Key Field Inner Join is most appropriate if all keys
are matched. For example: EKKO-EKPO based on EBELN. It
reduces the network traffic for selecting data from both
the tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of a domain? : abap data dictionary

1023


What are the different types of abap reports in sap?

1325


What is asynchronous update?

1029


What is a variable in the sap abap?

1038


What are the differences between a database index and a match code? : abap data dictionary

1206


Have you worked with support? How ticket comes to you? What were the timings for resolving tickets types of severity?

2042


What are the ways you can do the tuning?

1077


Name some system global variables you can use in abap programs?

1012


Explain the difference between open_form and close_form?

1009


Explain the difference between domain and data element? What are aggregate object?

1068


when u prefer lsmw?

1050


What is a modification assistant?

1042


What is the Process to transfer IDOC from Outbound System to Inbound system.

2161


What are screen painter and menu painter? : abap hr

1037


Explain lsmw?

1073