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 / 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


Please Help Members By Posting Answers For Below Questions

Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?

1024


What is a development class? : abap data dictionary

1216


What are the different message types available in the abap/4 ?

1025


What are types of select statements?

1052


What is the function of the transport system and workbench organizer?

1151


What are the function module in bdc?

1243


What should be declared explicitly in the corresponding abap/4 statements to access internal tables without header lines & why? : abap modularization

1104


What are screen painter and menu painter? : abap hr

1039


Which infotype records can not be deleted ? : abap hr

1083


What is a transport?

1116


Explain the different types of view?

1014


Which bdc you prefer? : abap bdc

1318


Explain what is step-loop?

1207


What are uses of foreign key?

1092


How to call a subroutine in sapscript?

1120