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

What are the disadvantages of logical databases?

1234


What is the difference between Check and Continue?

1145


What is the definition of modification in an sap system and how do they impact an upgrade?

1125


Explain what are the events used for logical database?

987


What are the page windows?

1017


what will happen if called program is not executable ?

2166


What are the different abap editors? What is the used of different editors in abap?

1060


Explain the use of insert and append statement in sap abap?

1092


How many types of size categories and data classes are there? : abap data dictionary

1108


What are different data types in abap/4?

1026


If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc

1082


What is an abap/4 query? : abap hr

1090


how to see the table output?

2222


Where the payroll results are stored

2242


What is the abap program name to process the batch input session automatically? : abap bdc

1238