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

Persistent class

1307


What happens if only one of the commands set screen and leave screen is used without using the other?

1049


What are the properties of selection screen?

1020


What are system variable in abap?

1065


What are the aggregate objects in the dictionary? : abap data dictionary

1151


What is the difference between sy-tabix and sy-index? Where it is used?

1270


Explain what is the difference between sy-tabix and sy-index? Where it is used?

1003


Explain how do you move on to the next screen in interactive reporting?

995


What are the data types of the abap/4 layer? : abap data dictionary

1167


What are the components in sap application server?

1099


What is Transactional based Application & Role based Application?

1507


What are the disadvantages of using explicit enhancement?

1992


What is database utility? : abap data dictionary

1033


8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?

2072


Is the basic list deleted when the new list is created?

1045