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

-------------Diff b/w Union and Unionall?

Answer Posted / sridevi

UNION will give only distinct values where as UNION ALL gives all the values including duplicates.Performance wise UNION ALL is faster than UNION because UNION needs to exclude duplicates.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of studio present in Cognos?

1032


What is an olap designer?

959


What is metric store database?

994


Can you explain the advantage of using shortcuts?

1025


How is cognos model organization works?

1082


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2564


What are the services provided in cognos 8?

1026


Can you define set to be cardinality?

1007


What is the difference between static and dynamic conditions?

1079


What is the difference between a data mart and a data warehouse?

1038


what is the difference between filter and condition?

1060


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1981


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2147


1. Explain your project.

2039


Can you explain a cognos controller?

1016