Interested to Buy Any Domain ? << Click Here >> for more details...
-------------Diff b/w Union and Unionall?
- 3 Answers
- 9243 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Can you define drill across?
How can I schedule reports in cognos?
What are types of batch available in cognos?
What is a Query Subject?
What is the report studio?
What is Online View?
What is the difference b/w macros and prompt?
New coloums are added in database, then how you know in report level
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What is meant by drill down?
What are all the types of indexes in Cognos?
What is the difference between Standard and Metrics folder?
What is the difference between set functions and filter function in dimensional data?
What is set to be Cognos configuration?
What is a Pivot?
