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 meaning of sap r/3?

1177


What are the fields in a bdc_tab table? : abap bdc

1105


Name the abap/4 modularization techniques?

1081


What are the value tables?

1079


What is smart forms? : abap hr

1088


What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary

1879


Explain the disadvantage of using exec sql statement in abap?

991


What are the system fields?

983


State the differences between database view & projection view? : abap data dictionary

1084


What is a report?

1252


what will happen if called program is not executable ?

2152


What are aggregated objects

974


What is synchronous update?

1010


What is the difference between a dialog program and a report?

1078


What are uses of foreign key?

1092