What is difference between Union and Union All ?
Answer / 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 |
what do you mean by security filter?
How do you optimize reports in microstartegy?
How to use consolidations in microstrategy report?
what do you mean by kimball?
Explain three-tier connection?
Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?
In document how to create metrics?Explain
What is the order of precedence of vldb properties?
static prompt in microstrategy.
At which levels you can set the vldb properties? Which level has the highest pecedence?
Can schema objects be copied across projects with microstrategy object manager?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?