-------------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
what are the dimensions that you have in your current project?list them?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Can you explain the advantage of using shortcuts?
How to apply securities for reports in cognos connection?
What you mean by drill across and what is the difference between drill through, drill across?
what is the difference between native sql and cognos sql?
What is Metrics designer?
------------------What is Inline Query?
How to create model and how to test model?
What is a Cube?
What is an olap designer?
What is a dimension?
What are all the types of gateway used in Cognos?
What do you understand by the term 'model durability'?
How the Bursting happens in same report and how to Print the bursting Report?