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

For Key Field Inner Join is most appropriate on the non-key
field for all entries is best

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between data elements and domains? : abap data dictionary

1088


On which even we can validate the input fields in module progams?

997


When the top-of-page event does get triggered?

1087


Explain difference between primary key and unique key?

938


Explain the difference between cluster tables and pool table?

1048


How would you suppress the display of a parameter on the selection screen?

985


How to handle error in session method? : abap bdc

1253


What is the difference between open_form and close_form?

1042


2)In production what is the user exit?

1905


the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....

1953


What is the maximum number of structures that can be included in a table or structure

1004


Double click function on the lists, identifying the line selected by the user on the list?

981


any 1 having notes on SAP-ABAP certification, or even if any 1 could provide the url for getting notes on SAP-ABAP certification, would be appreciated.

2339


What are the disadvantages of logical databases?

1164


How to convert normal function module to bapi?

2000