What is difference between Union and Union All ?
Answer Posted / sagar
1) By union ALL u will get duplicate records also(the records common between 2 tables 2 times) but Union gives u union of 2 tables
2) 'Union All' is faster than Union
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is fact degradation?
Does microstrategy intelligence server run on windows®, unix®, or linux®?
How do users receive only information that they want?
Explain heterogeneous mapping?
What are objects?
What are the programs that we can do with the microstrategy architect?
Explain fact constellation schema?
Your application mode has crashed. How would you get the instance back?
Explain system call error?
Explain the difference between rolap and molap?
Explain security role?
Your application mode has crashed. How would you run your i-server?
what are the different types of fact structures?
what do you mean by passthrough functions?
Difference between project merge and object manager in microstrategy?