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 / sashi

For all entires is more effiencent thatn the inner join , in
ineer jin we can only used up to 5 max of innerjoins inna
single statement.

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 dynpro? what are its components ?

1103


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 .....

2026


What is append structure?

1055


Have you processed BDCs ?

1081


What is the meaning of abap/4 editor integrated with abap/4 data dictionary?

1101


What are aggregated objects

990


Cds views

8431


What is a collect statement?

1038


Some Realtime Examples on Exits .

2185


What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr

1138


Where are you used type casting?

1360


How we can retrieve data using secondary index. Explain with simple example?

1174


How do you take care of performance issues in your ABAP programs?

1141


what are the critical issues u face in ur project?

2552


What are lock objects?

1030