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

When will the current screen processing terminates?

1067


How is time management and payroll is integrated? : sap abap hr

1040


What are roles and authorization objects?

1695


What are the user groups?

1025


How you attach search help to data element? : sap abap data dictionary

1135


What are the events in abap/4 language? : abap hr

1097


What are the page headers for secondary lists?

1053


What is an update task? : abap modularization

1082


How do you populate data into a multiple line field? : abap bdc

1139


Explain some essential objects in abap dictionary?

1182


Polymorphism real time scenario

1522


What are subroutines? : abap modularization

1113


How can we access the correction and transport system?

1075


How is conversion of data types done between abap/4 & external level? : abap data dictionary

1178


What happens when you post goods issue after delivery? How does the inventory get reduced after the delivery?

990